eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPAPBR dependencies on OE_ORDER_LINES_ALL

Line 6339: FROM oe_order_lines_all ool,

6335: -- whether the original sales order issue was inserted into
6336: -- the Revenue / COGS Matching data model.
6337: SELECT max(ool.reference_line_id)
6338: INTO l_ref_om_line_id
6339: FROM oe_order_lines_all ool,
6340: cst_revenue_cogs_match_lines crcml
6341: WHERE ool.line_id = i_ae_txn_rec.om_line_id
6342: AND ool.reference_line_id = crcml.cogs_om_line_id
6343: AND crcml.pac_cost_type_id = i_ae_txn_rec.cost_type_id

Line 6706: FROM oe_order_lines_all ool,

6702: -- whether the original sales order issue was inserted into
6703: -- the Revenue / COGS Matching data model.
6704: SELECT max(ool.reference_line_id)
6705: INTO l_ref_om_line_id
6706: FROM oe_order_lines_all ool,
6707: cst_revenue_cogs_match_lines crcml
6708: WHERE ool.line_id = i_ae_txn_rec.om_line_id
6709: AND ool.reference_line_id = crcml.cogs_om_line_id
6710: AND crcml.pac_cost_type_id = i_ae_txn_rec.cost_type_id

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

Line 10722: OE_ORDER_LINES_ALL oel

10718: oel.SOURCE_DOCUMENT_LINE_ID
10719: INTO
10720: l_req_line_id
10721: FROM
10722: OE_ORDER_LINES_ALL oel
10723: WHERE
10724: oel.LINE_ID = l_trx_source_line_id;
10725:
10726: ELSIF ( ( l_txn_action_id = 12