DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on OE_ORDER_HEADERS_ALL

Line 3792: from oe_order_headers_all h, oe_order_lines_all l

3788: END IF;
3789:
3790: select h.source_document_type_id
3791: into l_source_document_type_id
3792: from oe_order_headers_all h, oe_order_lines_all l
3793: where h.header_id = l.header_id
3794: and l.line_id = pLineId
3795: and rownum = 1;
3796:

Line 4565: oe_order_headers_all oeh,

4561: CURSOR c_rsv_details IS
4562: select reservation_id,reservation_quantity,supply_source_type_id
4563: from mtl_reservations mr,
4564: oe_order_lines_all oel,
4565: oe_order_headers_all oeh,
4566: oe_transaction_types_all ota,
4567: oe_transaction_types_tl otl,
4568: mtl_sales_orders mso
4569: where mr.demand_source_line_id = oel.line_id --ato item line id

Line 5685: oe_order_headers_all oeh,

5681: INTO l_reservation_id
5682: FROM
5683: mtl_reservations mr,
5684: oe_order_lines_all oel,
5685: oe_order_headers_all oeh,
5686: oe_transaction_types_all ota,
5687: oe_transaction_types_tl otl,
5688: mtl_sales_orders mso
5689: WHERE