APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 669: from MTL_SYSTEM_ITEMS_B

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

Line 871: from MTL_SYSTEM_ITEMS_B

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

Line 1272: from MTL_SYSTEM_ITEMS_B

1268: l_error_message VARCHAR2(4000);
1269: --
1270: /* CURSOR CTO_CUR(p_base_model IN NUMBER) IS
1271: select distinct inventory_item_id
1272: from MTL_SYSTEM_ITEMS_B
1273: where base_item_id = p_base_model
1274: and inventory_item_id <> p_inv_item_id;
1275: --
1276: */--Commented for bug 12952143

Line 1333: from MTL_SYSTEM_ITEMS_B

1329: IF l_serial_type = 1
1330: THEN
1331: select base_item_id
1332: into l_base_item_id
1333: from MTL_SYSTEM_ITEMS_B
1334: where inventory_item_id = p_inv_item_id
1335: and organization_id = p_inv_org_id;
1336:
1337: CSI_INV_TRXS_PKG.get_master_organization(p_inv_org_id, --added call for 12942740

Line 1354: from MTL_SYSTEM_ITEMS_B

1350: where serial_number = p_serial_number
1351: and inventory_item_id in
1352: (
1353: select inventory_item_id
1354: from MTL_SYSTEM_ITEMS_B
1355: where base_item_id = l_base_item_id
1356: and inventory_item_id <> p_inv_item_id
1357: and organization_id = l_master_organization_id
1358: );

Line 4839: FROM mtl_system_items_b

4835: FOR l_link IN p_instance_header_tbl.FIRST..p_instance_header_tbl.LAST
4836: LOOP
4837: SELECT nvl(ib_item_instance_class,'X')
4838: INTO l_link_type
4839: FROM mtl_system_items_b
4840: WHERE inventory_item_id=p_instance_header_tbl(l_link).inventory_item_id
4841: AND organization_id=p_instance_header_tbl(l_link).vld_organization_id;
4842:
4843: IF l_link_type='LINK'

Line 6100: FROM mtl_system_items_b

6096: END IF;
6097: ELSE
6098: SELECT eam_item_type
6099: INTO l_eam
6100: FROM mtl_system_items_b
6101: WHERE inventory_item_id = p_inventory_item_id
6102: AND organization_id = p_organization_id;
6103:
6104: IF l_eam IN (1,3)