APPS.INVCIINT dependencies on MTL_SYSTEM_ITEMS

Line 1352: FROM MTL_SYSTEM_ITEMS MSI

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

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

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

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

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

Line 3897: FROM MTL_SYSTEM_ITEMS MSI

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

Line 5165: FROM MTL_SYSTEM_ITEMS MSI

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