APPS.CSTPAPBR dependencies on OE_ORDER_HEADERS_ALL

Line 8977: l_order_type OE_ORDER_HEADERS_ALL.ORDER_TYPE_ID%TYPE;

8973: l_to_ou NUMBER;
8974: l_line_id NUMBER;
8975: l_header_id NUMBER;
8976: l_cust_id NUMBER;
8977: l_order_type OE_ORDER_HEADERS_ALL.ORDER_TYPE_ID%TYPE;
8978: l_ship_num NUMBER;
8979: l_req_line NUMBER;
8980: l_stmt_num NUMBER;
8981: l_pd_txfr_ind NUMBER;

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

9097: l_stmt_num := 40;
9098:
9099: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
9100: INTO l_line_id, l_header_id, l_cust_id, l_order_type
9101: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
9102: WHERE MMT.transaction_id = i_ae_txn_rec.transaction_id
9103: AND OEL.line_id = MMT.trx_source_line_id
9104: AND OEL.header_id = OEH.header_id;
9105:

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

9122: l_stmt_num := 60;
9123:
9124: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
9125: INTO l_line_id, l_header_id, l_cust_id, l_order_type
9126: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
9127: WHERE MMT.transaction_id = i_ae_txn_rec.xfer_transaction_id
9128: AND MMT.trx_source_line_id = OEL.line_id
9129: AND OEL.header_id = OEH.header_id;
9130:

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

9133: l_stmt_num := 70;
9134:
9135: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
9136: INTO l_line_id, l_header_id, l_cust_id, l_order_type
9137: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
9138: WHERE MMT.transaction_action_id = 21
9139: AND MMT.transaction_source_type_id = 8
9140: AND MMT.organization_id = l_from_org
9141: AND MMT.inventory_item_id = i_ae_txn_rec.inventory_item_id