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.CSI_UTL_PKG dependencies on OE_ORDER_LINES_ALL

Line 1647: oe_order_lines_all b,

1643: l_order_line_rec.currency_code,
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;

Line 1887: FROM oe_order_lines_all

1883: /* Added p_order_header_id as part of fix for Bug : 2897324 */
1884:
1885: SELECT line_id
1886: INTO x_split_ord_line_id
1887: FROM oe_order_lines_all
1888: WHERE split_from_line_id = p_order_line_id
1889: AND header_id = p_order_header_id;
1890:
1891: EXCEPTION

Line 1992: oe_order_lines_all oel

1988: CURSOR parent_inst_cur IS
1989: SELECT cii.instance_id,
1990: 'N' process_flag
1991: FROM csi_item_instances cii,
1992: oe_order_lines_all oel
1993: WHERE oel.line_id = p_parent_line_id
1994: AND cii.inventory_item_id = oel.inventory_item_id
1995: AND cii.last_oe_order_line_id = oel.line_id;
1996:

Line 2038: from oe_order_lines_all

2034: IF nvl(p_model_remnant_flag,'N') = 'Y' THEN
2035: BEGIN
2036: select sum(ordered_quantity)
2037: into l_order_line_qty
2038: from oe_order_lines_all
2039: where link_to_line_id = p_link_to_line_id
2040: and inventory_item_id = p_order_item_id
2041: and model_remnant_flag = 'Y';
2042: EXCEPTION

Line 2062: FROM oe_order_lines_all

2058:
2059: BEGIN
2060: SELECT ordered_quantity
2061: INTO l_ordered_quantity
2062: FROM oe_order_lines_all
2063: WHERE line_id = p_link_to_line_id;
2064:
2065: EXCEPTION
2066: WHEN no_data_found THEN

Line 2084: FROM oe_order_lines_all a,

2080: SELECT a.link_to_line_id,
2081: nvl(msi.comms_nl_trackable_flag,'N')
2082: INTO l_parent_line_id,
2083: l_ib_trackable_flag
2084: FROM oe_order_lines_all a,
2085: mtl_system_items msi,
2086: oe_system_parameters_all osp
2087: WHERE a.line_id = p_link_to_line_id
2088: AND osp.org_id = a.org_id

Line 2142: oe_order_lines_all orl,

2138: BEGIN
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

Line 2158: FROM oe_order_lines_all

2154:
2155: Begin
2156: SELECT link_to_line_id , line_id
2157: INTO x_link_to_line_id, l_line_id
2158: FROM oe_order_lines_all
2159: WHERE line_id = x_link_to_line_id;
2160:
2161: IF x_link_to_line_id IS NULL THEN
2162: l_found := TRUE;

Line 2333: WHERE exists (SELECT 'X' FROM oe_order_lines_all

2329: BEGIN
2330: SELECT 'Y'
2331: INTO l_leaf_node
2332: FROM sys.dual
2333: WHERE exists (SELECT 'X' FROM oe_order_lines_all
2334: WHERE header_id = p_order_line_rec.header_id
2335: AND link_to_line_id = p_order_line_rec.order_line_id);
2336:
2337: debug(' order line is not the leaf node in oe configuration. no explosion');

Line 3502: oe_order_lines_all oel,

3498: x_mtl_txn_rec.source_line_ref,
3499: x_mtl_txn_rec.source_transaction_date,
3500: x_mtl_txn_rec.inv_material_transaction_id
3501: FROM oe_order_headers_all oeh,
3502: oe_order_lines_all oel,
3503: mtl_material_transactions mmt
3504: WHERE mmt.transaction_id = p_mtl_transaction_id
3505: AND oel.line_id = mmt.trx_source_line_id
3506: AND oeh.header_id = oel.header_id;

Line 6139: OR (b.source_transaction_table = 'OE_ORDER_LINES_ALL' AND c.shippable_item_flag = 'N'))

6135: csi_t_transaction_lines b ,
6136: mtl_system_items_b c
6137: WHERE a.transaction_line_id = b.transaction_line_id
6138: AND ((b.source_transaction_table = 'WSH_DELIVERY_DETAILS' AND c.shippable_item_flag = 'Y')
6139: OR (b.source_transaction_table = 'OE_ORDER_LINES_ALL' AND c.shippable_item_flag = 'N'))
6140: AND a.instance_id IS NOT NULL ---meaning it is already processed. or it is Non Source
6141: AND a.source_txn_line_detail_id = c_partner_oe_tld
6142: AND a.inventory_item_id = c.inventory_item_id
6143: AND a.inv_organization_id = c.organization_id;

Line 6160: 'OE_ORDER_LINES_ALL')

6156:
6157: debug ('process status '|| p_txn_line_detail_tbl(i).processing_status);
6158:
6159: IF l_src_txn_table IN('WSH_DELIVERY_DETAILS' ,
6160: 'OE_ORDER_LINES_ALL')
6161: AND p_txn_line_detail_tbl(i).processing_status NOT IN
6162: ('UNPROCESSED','ERROR','SUBMIT','PROCESSED')
6163: THEN
6164: ---In Case of Non-Shippable Items Txn Detail Line may NOT

Line 6703: FROM oe_order_lines_all

6699: l_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
6700:
6701: CURSOR op_cur is
6702: SELECT line_id
6703: FROM oe_order_lines_all
6704: WHERE header_id = p_header_id
6705: AND link_to_line_id = p_parent_line_id
6706: ORDER BY line_number, shipment_number;
6707:

Line 7089: from oe_order_lines_all

7085: IF l_line_tbl(l_ol_ind).inventory_item_id <> l_next_item_id THEN
7086: BEGIN
7087: select sum(ordered_quantity)
7088: into l_order_line_qty
7089: from oe_order_lines_all
7090: where link_to_line_id = l_line_tbl(l_ol_ind).link_to_line_id
7091: and inventory_item_id = l_line_tbl(l_ol_ind).inventory_item_id
7092: and model_remnant_flag = 'Y';
7093: EXCEPTION