APPS.CSI_UTL_PKG dependencies on MTL_SYSTEM_ITEMS

Line 492: FROM mtl_system_items

488: api_log('get_primay_uom');
489:
490: SELECT primary_uom_code
491: INTO l_uom_code
492: FROM mtl_system_items
493: WHERE inventory_item_id = p_inv_item_id
494: AND organization_id = p_inv_org_id;
495:
496: RETURN l_uom_code;

Line 1538: FROM mtl_system_items

1534: /*----------------------------------------------------------*/
1535:
1536: SELECT serial_number_control_code
1537: INTO l_serial_code
1538: FROM mtl_system_items
1539: WHERE inventory_item_id = p_inv_item_id
1540: AND organization_id = p_inv_org_id;
1541:
1542: RETURN l_serial_code;

Line 2085: mtl_system_items msi,

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
2089: AND msi.inventory_item_id = a.inventory_item_id

Line 2141: FROM mtl_system_items msi,

2137:
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)

Line 2299: l_bom_item_type mtl_system_items.bom_item_type%TYPE;

2295: p_order_line_rec IN csi_order_ship_pub.order_line_rec)
2296: RETURN BOOLEAN
2297: IS
2298:
2299: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
2300: l_bom_found varchar2(1);
2301: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2302: l_explosion_level number;
2303: l_explode_flag varchar2(3);

Line 5960: FROM mtl_system_items

5956: l_item_control_rec.ib_trackable_flag,
5957: l_item_control_rec.reservable_type,
5958: l_item_control_rec.shippable_flag,
5959: l_item_control_rec.transactable_flag
5960: FROM mtl_system_items
5961: WHERE inventory_item_id = l_item_control_rec.inventory_item_id
5962: AND organization_id = l_item_control_rec.organization_id;
5963:
5964: EXCEPTION

Line 6136: mtl_system_items_b c

6132: ---For Shippable and Non-shippable Items--
6133: SELECT a.*
6134: FROM csi_t_txn_line_details a ,
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

Line 6791: FROM mtl_system_items msi

6787: IF l_line_tbl(l_ind).item_type_code <> 'CONFIG' THEN
6788:
6789: SELECT nvl(msi.comms_nl_trackable_flag,'N')
6790: INTO l_ib_trackable_flag
6791: FROM mtl_system_items msi
6792: WHERE msi.inventory_item_id = l_line_tbl(l_ind).inventory_item_id
6793: AND msi.organization_id = p_om_vld_org_id;
6794:
6795: /* if trackable populate it for the final out table */