APPS.OTA_OM_UPD_API dependencies on OE_ORDER_LINES_ALL

Line 117: OE_ORDER_LINES_ALL OL

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:
121:

Line 434: OE_ORDER_LINES_ALL OL

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:
438:

Line 442: Select count(*)into l_count from oe_order_lines_all

438:
439: BEGIN
440: hr_utility.set_location('Entering:'||l_proc, 5);
441:
442: Select count(*)into l_count from oe_order_lines_all
443: where reference_line_id = p_line_id;
444: if l_count = 0 then
445:
446: OPEN C_ORDER;