APPS.INVCIINT dependencies on MTL_SYSTEM_ITEMS

Line 1353: FROM MTL_SYSTEM_ITEMS MSI

1349: IF (P_Container_Item_Id IS NOT NULL) THEN
1350:
1351: SELECT Inventory_Item_Id
1352: INTO Temp_Container_Item_Id
1353: FROM MTL_SYSTEM_ITEMS MSI
1354: WHERE MSI.Inventory_Item_Id = P_Container_Item_Id
1355: AND MSI.Container_Item_Flag = 'Y'
1356: AND MSI.Organization_Id = P_Container_Organization_Id;
1357:

Line 1400: 'UPPER(MTL_SYSTEM_ITEMS.Container_Item_Flag) = ''Y'''

1396: STRUCTURE_NUMBER=> L_StructNum,
1397: CONCAT_SEGMENTS => P_Container_Item,
1398: DATA_SET => P_Container_Organization_Id,
1399: WHERE_CLAUSE =>
1400: 'UPPER(MTL_SYSTEM_ITEMS.Container_Item_Flag) = ''Y'''
1401: );
1402:
1403: if L_Success then
1404: P_Container_Item_Id :=

Line 2588: 'UPPER(MTL_SYSTEM_ITEMS.Container_Item_Flag) = ''Y'''

2584: STRUCTURE_NUMBER=> L_StructNum,
2585: CONCAT_SEGMENTS => L_ConcatSegs,
2586: DATA_SET => P_Container_Organization_Id,
2587: WHERE_CLAUSE =>
2588: 'UPPER(MTL_SYSTEM_ITEMS.Container_Item_Flag) = ''Y'''
2589: );
2590:
2591: if L_Success then
2592: P_Container_Item_Id :=

Line 3898: FROM MTL_SYSTEM_ITEMS MSI

3894: IF (P_Inventory_Item_Id IS NOT NULL) THEN
3895:
3896: SELECT Inventory_Item_Id
3897: INTO Temp_Inventory_Item_Id
3898: FROM MTL_SYSTEM_ITEMS MSI
3899: WHERE MSI.Inventory_Item_Id = P_Inventory_Item_Id
3900: AND MSI.Organization_Id = P_Master_Organization_Id
3901: AND NVL(MSI.Approval_Status,'A') = 'A';--Added for 11.5.10 PLM
3902:

Line 5166: FROM MTL_SYSTEM_ITEMS MSI

5162: --PLM 11.5.10 validation. XRef can be done only for Approved Items
5163: IF (P_Inventory_Item_Id IS NOT NULL) THEN
5164: SELECT Inventory_Item_Id
5165: INTO Temp_Inventory_Item_Id
5166: FROM MTL_SYSTEM_ITEMS MSI
5167: WHERE MSI.Inventory_Item_Id = P_Inventory_Item_Id
5168: AND MSI.Organization_Id = P_Master_Organization_Id
5169: AND NVL(MSI.Approval_Status,'A') = 'A';
5170: