APPS.CSTPAPBR dependencies on OE_ORDER_HEADERS_ALL

Line 9418: l_order_type OE_ORDER_HEADERS_ALL.ORDER_TYPE_ID%TYPE;

9414: l_to_ou NUMBER;
9415: l_line_id NUMBER;
9416: l_header_id NUMBER;
9417: l_cust_id NUMBER;
9418: l_order_type OE_ORDER_HEADERS_ALL.ORDER_TYPE_ID%TYPE;
9419: l_ship_num NUMBER;
9420: l_req_line NUMBER;
9421: l_stmt_num NUMBER;
9422: l_pd_txfr_ind NUMBER;

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

9538: l_stmt_num := 40;
9539:
9540: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
9541: INTO l_line_id, l_header_id, l_cust_id, l_order_type
9542: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
9543: WHERE MMT.transaction_id = i_ae_txn_rec.transaction_id
9544: AND OEL.line_id = MMT.trx_source_line_id
9545: AND OEL.header_id = OEH.header_id;
9546:

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

9563: l_stmt_num := 60;
9564:
9565: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
9566: INTO l_line_id, l_header_id, l_cust_id, l_order_type
9567: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
9568: WHERE MMT.transaction_id = i_ae_txn_rec.xfer_transaction_id
9569: AND MMT.trx_source_line_id = OEL.line_id
9570: AND OEL.header_id = OEH.header_id;
9571:

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

9574: l_stmt_num := 70;
9575:
9576: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
9577: INTO l_line_id, l_header_id, l_cust_id, l_order_type
9578: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
9579: WHERE MMT.transaction_action_id = 21
9580: AND MMT.transaction_source_type_id = 8
9581: AND MMT.organization_id = l_from_org
9582: AND MMT.inventory_item_id = i_ae_txn_rec.inventory_item_id