DBA Data[Home] [Help]

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 3544: oe_order_lines_all oel,

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
3548: AND oeh.header_id = oel.header_id;

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

6214: csi_t_transaction_lines b ,
6215: mtl_system_items_b c
6216: WHERE a.transaction_line_id = b.transaction_line_id
6217: AND ((b.source_transaction_table = 'WSH_DELIVERY_DETAILS' AND c.shippable_item_flag = 'Y')
6218: OR (b.source_transaction_table = 'OE_ORDER_LINES_ALL' AND c.shippable_item_flag = 'N'))
6219: AND a.instance_id IS NOT NULL ---meaning it is already processed. or it is Non Source
6220: AND a.source_txn_line_detail_id = c_partner_oe_tld
6221: AND a.inventory_item_id = c.inventory_item_id
6222: AND a.inv_organization_id = c.organization_id;

Line 6239: 'OE_ORDER_LINES_ALL')

6235:
6236: debug ('process status '|| p_txn_line_detail_tbl(i).processing_status);
6237:
6238: IF l_src_txn_table IN('WSH_DELIVERY_DETAILS' ,
6239: 'OE_ORDER_LINES_ALL')
6240: AND p_txn_line_detail_tbl(i).processing_status NOT IN
6241: ('UNPROCESSED','ERROR','SUBMIT','PROCESSED')
6242: THEN
6243: ---In Case of Non-Shippable Items Txn Detail Line may NOT

Line 6791: FROM oe_order_lines_all

6787: l_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
6788:
6789: CURSOR op_cur is
6790: SELECT line_id
6791: FROM oe_order_lines_all
6792: WHERE header_id = p_header_id
6793: AND link_to_line_id = p_parent_line_id
6794: ORDER BY line_number, shipment_number;
6795:

Line 7177: from oe_order_lines_all

7173: IF l_line_tbl(l_ol_ind).inventory_item_id <> l_next_item_id THEN
7174: BEGIN
7175: select sum(ordered_quantity)
7176: into l_order_line_qty
7177: from oe_order_lines_all
7178: where link_to_line_id = l_line_tbl(l_ol_ind).link_to_line_id
7179: and inventory_item_id = l_line_tbl(l_ol_ind).inventory_item_id
7180: and model_remnant_flag = 'Y';
7181: EXCEPTION