APPS.CSI_UTL_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 1648: oe_order_headers_all c

1644: l_order_line_rec.model_remnant_flag, --4344316
1645: l_order_line_rec.source_code
1646: FROM mtl_material_transactions mmt,
1647: oe_order_lines_all b,
1648: oe_order_headers_all c
1649: WHERE mmt.trx_source_line_id = b.line_id
1650: AND b.header_id = c.header_id
1651: AND mmt.transaction_id = p_mtl_transaction_id;
1652:

Line 2143: oe_order_headers_all orh

2139: SELECT 'x'
2140: INTO l_dummy
2141: FROM mtl_system_items msi,
2142: oe_order_lines_all orl,
2143: oe_order_headers_all orh
2144: WHERE msi.inventory_item_id = orl.inventory_item_id
2145: AND msi.organization_id = NVL(orl.ship_from_org_id,orh.ship_from_org_id)
2146: AND orl.header_id = orh.header_id
2147: AND msi.comms_nl_trackable_flag = 'Y'

Line 3543: FROM oe_order_headers_all oeh,

3539: x_mtl_txn_rec.source_line_ref_id,
3540: x_mtl_txn_rec.source_line_ref,
3541: x_mtl_txn_rec.source_transaction_date,
3542: x_mtl_txn_rec.inv_material_transaction_id
3543: FROM oe_order_headers_all oeh,
3544: oe_order_lines_all oel,
3545: mtl_material_transactions mmt
3546: WHERE mmt.transaction_id = p_mtl_transaction_id
3547: AND oel.line_id = mmt.trx_source_line_id