APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 668: from MTL_SYSTEM_ITEMS_B

664: l_cst_grp_id NUMBER;
665: --
666: CURSOR CTO_CUR(p_base_model IN NUMBER) IS
667: select distinct inventory_item_id
668: from MTL_SYSTEM_ITEMS_B
669: where base_item_id = p_base_model
670: and inventory_item_id <> p_inv_item_id;
671: --
672: process_next EXCEPTION;

Line 870: from MTL_SYSTEM_ITEMS_B

866: l_base_item_id := NULL;
867: Begin
868: select base_item_id
869: into l_base_item_id
870: from MTL_SYSTEM_ITEMS_B
871: where inventory_item_id = p_inv_item_id
872: and organization_id = p_inv_org_id;
873: Exception
874: when others then

Line 1243: from MTL_SYSTEM_ITEMS_B

1239: l_item_id NUMBER;
1240: --
1241: CURSOR CTO_CUR(p_base_model IN NUMBER) IS
1242: select distinct inventory_item_id
1243: from MTL_SYSTEM_ITEMS_B
1244: where base_item_id = p_base_model
1245: and inventory_item_id <> p_inv_item_id;
1246: --
1247: comp_error EXCEPTION;

Line 1303: from MTL_SYSTEM_ITEMS_B

1299: IF l_serial_type = 1
1300: THEN
1301: select base_item_id
1302: into l_base_item_id
1303: from MTL_SYSTEM_ITEMS_B
1304: where inventory_item_id = p_inv_item_id
1305: and organization_id = p_inv_org_id;
1306: --
1307: IF l_base_item_id IS NOT NULL THEN

Line 4753: FROM mtl_system_items_b

4749: FOR l_link IN p_instance_header_tbl.FIRST..p_instance_header_tbl.LAST
4750: LOOP
4751: SELECT nvl(ib_item_instance_class,'X')
4752: INTO l_link_type
4753: FROM mtl_system_items_b
4754: WHERE inventory_item_id=p_instance_header_tbl(l_link).inventory_item_id
4755: AND organization_id=p_instance_header_tbl(l_link).vld_organization_id;
4756:
4757: IF l_link_type='LINK'

Line 5847: FROM mtl_system_items_b

5843: END IF;
5844: ELSE
5845: SELECT eam_item_type
5846: INTO l_eam
5847: FROM mtl_system_items_b
5848: WHERE inventory_item_id = p_inventory_item_id
5849: AND organization_id = p_organization_id;
5850:
5851: IF l_eam IN (1,3)