DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on OE_ORDER_HEADERS_ALL

Line 3770: from oe_order_headers_all h, oe_order_lines_all l

3766: END IF;
3767:
3768: select h.source_document_type_id
3769: into l_source_document_type_id
3770: from oe_order_headers_all h, oe_order_lines_all l
3771: where h.header_id = l.header_id
3772: and l.line_id = pLineId
3773: and rownum = 1;
3774:

Line 4541: oe_order_headers_all oeh,

4537: CURSOR c_rsv_details IS
4538: select reservation_id,reservation_quantity,supply_source_type_id
4539: from mtl_reservations mr,
4540: oe_order_lines_all oel,
4541: oe_order_headers_all oeh,
4542: oe_transaction_types_all ota,
4543: oe_transaction_types_tl otl,
4544: mtl_sales_orders mso
4545: where mr.demand_source_line_id = oel.line_id --ato item line id

Line 5661: oe_order_headers_all oeh,

5657: INTO l_reservation_id
5658: FROM
5659: mtl_reservations mr,
5660: oe_order_lines_all oel,
5661: oe_order_headers_all oeh,
5662: oe_transaction_types_all ota,
5663: oe_transaction_types_tl otl,
5664: mtl_sales_orders mso
5665: WHERE