DBA Data[Home] [Help]

APPS.CST_TPRICE_PVT dependencies on OE_ORDER_LINES_ALL

Line 307: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL

303: l_stmt_num := 120;
304:
305: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
306: INTO l_line_id, l_header_id, l_cust_id, l_order_type
307: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
308: WHERE MMT.transaction_id = p_txn_id
309: AND OEL.line_id = MMT.trx_source_line_id
310: AND OEL.header_id = OEH.header_id;
311: --

Line 335: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL

331: l_stmt_num := 135;
332:
333: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
334: INTO l_line_id, l_header_id, l_cust_id, l_order_type
335: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
336: WHERE MMT.transaction_id = l_txf_txn_id
337: AND MMT.trx_source_line_id = OEL.line_id
338: AND OEL.header_id = OEH.header_id;
339: else

Line 344: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL

340: l_stmt_num := 140;
341:
342: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
343: INTO l_line_id, l_header_id, l_cust_id, l_order_type
344: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
345: WHERE MMT.transaction_action_id = 21
346: AND MMT.transaction_source_type_id = 8
347: AND MMT.organization_id = l_from_org
348: AND MMT.inventory_item_id = p_item_id