GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle Apps  >  ONT

 Print  |  
Question:  Oracle apps : conversion of holds

Answer: How is conversion of holds done using API? What are the tables affected?what are the fields to be passed & to which base tables?


October 10, 2009 13:12:41 #1
 Adi_phaniK   Member Since: September 2009    Total Comments: 6 

RE: Oracle apps : conversion of holds
 
The tables effected are

oe_hold_definitions (contains hold name would be defined as apart of setup)
oe_hold_sources (hold applied info would be saved in this)
oe_order_holds (contins the hold info in this as well)


Data to be passed sales order header id, order line id, hold id (type of hold), hold code like OEOH means hold at the header level, OEOL hold at the line level.

Hope this helps!
     

 

Back To Question