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 6039: FROM mtl_system_items

6035: l_item_control_rec.ib_trackable_flag,
6036: l_item_control_rec.reservable_type,
6037: l_item_control_rec.shippable_flag,
6038: l_item_control_rec.transactable_flag
6039: FROM mtl_system_items
6040: WHERE inventory_item_id = l_item_control_rec.inventory_item_id
6041: AND organization_id = l_item_control_rec.organization_id;
6042:
6043: EXCEPTION

Line 6215: mtl_system_items_b c

6211: ---For Shippable and Non-shippable Items--
6212: SELECT a.*
6213: FROM csi_t_txn_line_details a ,
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

Line 6879: FROM mtl_system_items msi

6875: IF l_line_tbl(l_ind).item_type_code <> 'CONFIG' THEN
6876:
6877: SELECT nvl(msi.comms_nl_trackable_flag,'N')
6878: INTO l_ib_trackable_flag
6879: FROM mtl_system_items msi
6880: WHERE msi.inventory_item_id = l_line_tbl(l_ind).inventory_item_id
6881: AND msi.organization_id = p_om_vld_org_id;
6882:
6883: /* if trackable populate it for the final out table */

Line 7418: mtl_system_items_b1_kfv sysitems,

7414: okc_k_lines_b tl,
7415: okc_statuses_v sts,
7416: okc_k_items sli,
7417: okc_k_items li,
7418: mtl_system_items_b1_kfv sysitems,
7419: okc_line_styles_v tlst
7420: where sl.id = sli.cle_id
7421: and sl.sts_code=sts.code
7422: and tl.lse_id = tlst.id