DBA Data[Home] [Help]

APPS.CSTPAPBR dependencies on OE_ORDER_LINES_ALL

Line 6624: FROM oe_order_lines_all ool,

6620: -- whether the original sales order issue was inserted into
6621: -- the Revenue / COGS Matching data model.
6622: SELECT max(ool.reference_line_id)
6623: INTO l_ref_om_line_id
6624: FROM oe_order_lines_all ool,
6625: cst_revenue_cogs_match_lines crcml
6626: WHERE ool.line_id = i_ae_txn_rec.om_line_id
6627: AND ool.reference_line_id = crcml.cogs_om_line_id
6628: AND crcml.pac_cost_type_id = i_ae_txn_rec.cost_type_id

Line 7014: FROM oe_order_lines_all ool,

7010: -- whether the original sales order issue was inserted into
7011: -- the Revenue / COGS Matching data model.
7012: SELECT max(ool.reference_line_id)
7013: INTO l_ref_om_line_id
7014: FROM oe_order_lines_all ool,
7015: cst_revenue_cogs_match_lines crcml
7016: WHERE ool.line_id = i_ae_txn_rec.om_line_id
7017: AND ool.reference_line_id = crcml.cogs_om_line_id
7018: AND crcml.pac_cost_type_id = i_ae_txn_rec.cost_type_id

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

Line 11206: OE_ORDER_LINES_ALL oel

11202: oel.SOURCE_DOCUMENT_LINE_ID
11203: INTO
11204: l_req_line_id
11205: FROM
11206: OE_ORDER_LINES_ALL oel
11207: WHERE
11208: oel.LINE_ID = l_trx_source_line_id;
11209:
11210: ELSIF ( ( l_txn_action_id = 12