DBA Data[Home] [Help]

APPS.INV_DCP_PVT dependencies on MTL_PARAMETERS

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