DBA Data[Home] [Help]

APPS.INV_DCP_PVT dependencies on MTL_SECONDARY_LOCATORS

Line 1060: FROM MTL_SECONDARY_LOCATORS MSL,

1056: AND transaction_action_id not in (24,30)
1057: AND inventory_item_id <> -1
1058: AND NOT EXISTS (
1059: SELECT NULL
1060: FROM MTL_SECONDARY_LOCATORS MSL,
1061: MTL_SYSTEM_ITEMS MSI
1062: WHERE MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1063: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1064: AND MSI.RESTRICT_LOCATORS_CODE = 1

Line 1110: FROM MTL_SECONDARY_LOCATORS MSL,

1106: AND TRANSFER_TO_LOCATION IS NOT NULL
1107: AND inventory_item_id <> -1
1108: AND NOT EXISTS (
1109: SELECT NULL
1110: FROM MTL_SECONDARY_LOCATORS MSL,
1111: MTL_SYSTEM_ITEMS MSI
1112: WHERE MSI.ORGANIZATION_ID = decode(MMTT.TRANSACTION_ACTION_ID,2,
1113: MMTT.ORGANIZATION_ID,5,MMTT.ORGANIZATION_ID, MMTT.TRANSFER_ORGANIZATION)
1114: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID