APPS.CSI_II_RELATIONSHIPS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 3267: ,mtl_system_items_b msi

3263: BEGIN
3264: SELECT msi.ib_item_instance_class
3265: INTO l_link
3266: FROM csi_item_instances cii
3267: ,mtl_system_items_b msi
3268: WHERE cii.instance_id = p_instance_id
3269: AND msi.inventory_item_id=cii.inventory_item_id
3270: AND msi.organization_id=cii.last_vld_organization_id
3271: AND msi.ib_item_instance_class = l_class;

Line 5776: from MTL_SYSTEM_ITEMS_B

5772: -- items to be transacted with the serial number. Hence other locations are not considered.
5773: Begin
5774: select serial_number_control_code
5775: into l_srl_ctl
5776: from MTL_SYSTEM_ITEMS_B
5777: where inventory_item_id = l_item_id
5778: and organization_id = l_vld_org;
5779: --
5780: IF l_srl_ctl = 6 THEN

Line 6410: from MTL_SYSTEM_ITEMS_B

6406: -- items to be transacted with the serial number. Hence other locations are not considered.
6407: Begin
6408: select serial_number_control_code
6409: into l_srl_ctl
6410: from MTL_SYSTEM_ITEMS_B
6411: where inventory_item_id = l_item_id
6412: and organization_id = l_vld_org;
6413: --
6414: IF l_srl_ctl = 6 THEN

Line 6969: FROM mtl_system_items

6965: ,l_bom_item_type
6966: ,l_pick_comp_flag
6967: ,l_base_item_id
6968: ,l_repl_order_flag
6969: FROM mtl_system_items
6970: WHERE inventory_item_id = l_inventory_item_id
6971: AND organization_id = l_vld_org_id ;
6972: -- Item is under serial control but serial_number is NULL
6973: -- '1' stands for - No serial number control

Line 7067: FROM mtl_system_items

7063: ,l_bom_item_type
7064: ,l_pick_comp_flag
7065: ,l_base_item_id -- fix for bug 2304221
7066: ,l_repl_order_flag
7067: FROM mtl_system_items
7068: WHERE inventory_item_id = l_inventory_item_id
7069: AND organization_id = l_vld_org_id ;
7070: -- Item is under serial control but serial_number is NULL
7071: -- '1' stands for - No serial number control