APPS.INV_DCP_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 894: FROM MTL_SECONDARY_INVENTORIES MSI

890: AND ((TRANSACTION_ACTION_ID in (1,2,3,30,31,5)
891: AND inventory_item_id <> -1
892: AND EXISTS (
893: SELECT 'X'
894: FROM MTL_SECONDARY_INVENTORIES MSI
895: WHERE MSI.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
896: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
897: AND MSI.QUANTITY_TRACKED = 2))
898: OR (TRANSACTION_ACTION_ID = 21

Line 901: FROM MTL_SECONDARY_INVENTORIES MSI,

897: AND MSI.QUANTITY_TRACKED = 2))
898: OR (TRANSACTION_ACTION_ID = 21
899: AND EXISTS (
900: SELECT 'X'
901: FROM MTL_SECONDARY_INVENTORIES MSI,
902: MTL_SYSTEM_ITEMS ITM
903: WHERE MSI.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
904: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
905: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID

Line 923: FROM MTL_SECONDARY_INVENTORIES MSI,

919: AND TRANSACTION_ACTION_ID in (2,5)
920: AND inventory_item_id <> -1
921: AND EXISTS (
922: SELECT 'X'
923: FROM MTL_SECONDARY_INVENTORIES MSI,
924: MTL_SYSTEM_ITEMS ITM
925: WHERE MSI.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
926: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
927: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID

Line 933: FROM MTL_SECONDARY_INVENTORIES MSI,

929: AND ITM.INVENTORY_ASSET_FLAG = 'Y'
930: AND MSI.ASSET_INVENTORY = 2)
931: AND EXISTS (
932: SELECT 'X'
933: FROM MTL_SECONDARY_INVENTORIES MSI,
934: MTL_SYSTEM_ITEMS ITM
935: WHERE MSI.SECONDARY_INVENTORY_NAME = MMTT.TRANSFER_SUBINVENTORY
936: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
937: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID

Line 953: FROM MTL_SECONDARY_INVENTORIES MSI

949: AND TRANSACTION_ACTION_ID = 3
950: AND inventory_item_id <> -1
951: AND EXISTS (
952: SELECT 'X'
953: FROM MTL_SECONDARY_INVENTORIES MSI
954: WHERE MSI.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
955: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
956: AND MSI.ASSET_INVENTORY = 2)
957: AND EXISTS (

Line 959: FROM MTL_SECONDARY_INVENTORIES MSI

955: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
956: AND MSI.ASSET_INVENTORY = 2)
957: AND EXISTS (
958: SELECT 'X'
959: FROM MTL_SECONDARY_INVENTORIES MSI
960: WHERE MSI.SECONDARY_INVENTORY_NAME = MMTT.TRANSFER_SUBINVENTORY
961: AND MSI.ORGANIZATION_ID = MMTT.TRANSFER_ORGANIZATION
962: AND MSI.ASSET_INVENTORY = 1);
963:

Line 975: FROM MTL_SECONDARY_INVENTORIES MSI

971: AND inventory_item_id <> -1
972: AND ((TRANSACTION_ACTION_ID in (1,2,3,30,31,5)
973: AND EXISTS (
974: SELECT 'X'
975: FROM MTL_SECONDARY_INVENTORIES MSI
976: WHERE MSI.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
977: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
978: AND MSI.QUANTITY_TRACKED = 2)
979: )) ;

Line 992: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I

988: AND transaction_action_id not in (24,30)
989: AND inventory_item_id <> -1
990: AND EXISTS (
991: SELECT 'x'
992: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
993: WHERE I.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
994: AND S.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
995: AND P.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
996: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 1019: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I

1015: AND inventory_item_id <> -1
1016: AND transaction_action_id not in (24,30)
1017: AND EXISTS (
1018: SELECT 'x'
1019: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
1020: WHERE I.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1021: AND S.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
1022: AND P.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1023: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 1039: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I

1035: AND transaction_action_id not in (24,30)
1036: AND inventory_item_id <> -1
1037: AND EXISTS (
1038: SELECT 'x'
1039: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
1040: WHERE I.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1041: AND S.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
1042: AND P.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1043: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID