DBA Data[Home] [Help]

APPS.OTA_OM_UPD_API dependencies on OE_ORDER_HEADERS_ALL

Line 116: FROM OE_ORDER_HEADERS_ALL OH,

112: SELECT OH.ORDER_NUMBER ,
113: OH.HEADER_ID,
114: OH.ORG_ID,
115: OL.ordered_quantity
116: FROM OE_ORDER_HEADERS_ALL OH,
117: OE_ORDER_LINES_ALL OL
118: WHERE OH.HEADER_ID = OL.HEADER_ID AND
119: OL.LINE_ID = p_line_id;
120:

Line 433: FROM OE_ORDER_HEADERS_ALL OH,

429: oh.ship_to_contact_id ,
430: ol.line_type_id,
431: ol.commitment_id,
432: oh.org_id
433: FROM OE_ORDER_HEADERS_ALL OH,
434: OE_ORDER_LINES_ALL OL
435: WHERE OH.HEADER_ID = OL.HEADER_ID AND
436: OL.LINE_ID = p_line_id;
437: