VIEW: APPS.MTL_PHY_INV_TAGS_COST_V

Source

View Text - Preformatted

SELECT TAG_ID , PHYSICAL_INVENTORY_ID , MPIT.ORGANIZATION_ID , MPIT.LAST_UPDATE_DATE , MPIT.LAST_UPDATED_BY , MPIT.CREATION_DATE , MPIT.CREATED_BY , MPIT.LAST_UPDATE_LOGIN , VOID_FLAG , TAG_NUMBER , ADJUSTMENT_ID , MPIT.INVENTORY_ITEM_ID , TAG_QUANTITY , TAG_UOM , TAG_QUANTITY_AT_STANDARD_UOM , STANDARD_UOM , SUBINVENTORY , MPIT.LOCATOR_ID , LOT_NUMBER , LOT_EXPIRATION_DATE , REVISION , SERIAL_NUM , COUNTED_BY_EMPLOYEE_ID , LOT_SERIAL_CONTROLS , MPIT.ATTRIBUTE_CATEGORY , MPIT.ATTRIBUTE1 , MPIT.ATTRIBUTE2 , MPIT.ATTRIBUTE3 , MPIT.ATTRIBUTE4 , MPIT.ATTRIBUTE5 , MPIT.ATTRIBUTE6 , MPIT.ATTRIBUTE7 , MPIT.ATTRIBUTE8 , MPIT.ATTRIBUTE9 , MPIT.ATTRIBUTE10 , MPIT.ATTRIBUTE11 , MPIT.ATTRIBUTE12 , MPIT.ATTRIBUTE13 , MPIT.ATTRIBUTE14 , MPIT.ATTRIBUTE15 , MPIT.REQUEST_ID , MPIT.PROGRAM_APPLICATION_ID , MPIT.PROGRAM_ID , MPIT.PROGRAM_UPDATE_DATE , CCICV.ITEM_COST , MPIT.PARENT_LPN_ID , MPIT.OUTERMOST_LPN_ID , MPIT.COST_GROUP_ID FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT, CST_CG_ITEM_COSTS_VIEW CCICV, MTL_PARAMETERS MP WHERE MPIT.LOCATOR_ID IS NULL AND CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD, 1, 1, NVL(MPIT.COST_GROUP_ID, 1)) UNION ALL SELECT TAG_ID, PHYSICAL_INVENTORY_ID, MPIT.ORGANIZATION_ID, MPIT.LAST_UPDATE_DATE, MPIT.LAST_UPDATED_BY, MPIT.CREATION_DATE, MPIT.CREATED_BY, MPIT.LAST_UPDATE_LOGIN, VOID_FLAG, TAG_NUMBER , ADJUSTMENT_ID , MPIT.INVENTORY_ITEM_ID, TAG_QUANTITY , TAG_UOM , TAG_QUANTITY_AT_STANDARD_UOM, STANDARD_UOM, SUBINVENTORY, MPIT.LOCATOR_ID, LOT_NUMBER, LOT_EXPIRATION_DATE, REVISION, SERIAL_NUM, COUNTED_BY_EMPLOYEE_ID , LOT_SERIAL_CONTROLS , MPIT.ATTRIBUTE_CATEGORY , MPIT.ATTRIBUTE1, MPIT.ATTRIBUTE2, MPIT.ATTRIBUTE3, MPIT.ATTRIBUTE4, MPIT.ATTRIBUTE5, MPIT.ATTRIBUTE6, MPIT.ATTRIBUTE7, MPIT.ATTRIBUTE8, MPIT.ATTRIBUTE9, MPIT.ATTRIBUTE10, MPIT.ATTRIBUTE11, MPIT.ATTRIBUTE12, MPIT.ATTRIBUTE13, MPIT.ATTRIBUTE14, MPIT.ATTRIBUTE15, MPIT.REQUEST_ID, MPIT.PROGRAM_APPLICATION_ID, MPIT.PROGRAM_ID, MPIT.PROGRAM_UPDATE_DATE , 0 ITEM_COST , MPIT.PARENT_LPN_ID , MPIT.OUTERMOST_LPN_ID , MPIT.COST_GROUP_ID FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT WHERE MPIT.LOCATOR_ID IS NULL AND NOT EXISTS (SELECT 'x' FROM CST_CG_ITEM_COSTS_VIEW CCICV, MTL_PARAMETERS MP WHERE CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD, 1, 1, NVL(MPIT.COST_GROUP_ID, 1))) UNION ALL SELECT TAG_ID, PHYSICAL_INVENTORY_ID, MPIT.ORGANIZATION_ID, MPIT.LAST_UPDATE_DATE, MPIT.LAST_UPDATED_BY, MPIT.CREATION_DATE, MPIT.CREATED_BY, MPIT.LAST_UPDATE_LOGIN, VOID_FLAG, TAG_NUMBER , ADJUSTMENT_ID , MPIT.INVENTORY_ITEM_ID, TAG_QUANTITY , TAG_UOM , TAG_QUANTITY_AT_STANDARD_UOM, STANDARD_UOM, SUBINVENTORY, MPIT.LOCATOR_ID, LOT_NUMBER, LOT_EXPIRATION_DATE, REVISION, SERIAL_NUM, COUNTED_BY_EMPLOYEE_ID , LOT_SERIAL_CONTROLS , MPIT.ATTRIBUTE_CATEGORY , MPIT.ATTRIBUTE1, MPIT.ATTRIBUTE2, MPIT.ATTRIBUTE3, MPIT.ATTRIBUTE4, MPIT.ATTRIBUTE5, MPIT.ATTRIBUTE6, MPIT.ATTRIBUTE7, MPIT.ATTRIBUTE8, MPIT.ATTRIBUTE9, MPIT.ATTRIBUTE10, MPIT.ATTRIBUTE11, MPIT.ATTRIBUTE12, MPIT.ATTRIBUTE13, MPIT.ATTRIBUTE14, MPIT.ATTRIBUTE15, MPIT.REQUEST_ID, MPIT.PROGRAM_APPLICATION_ID, MPIT.PROGRAM_ID, MPIT.PROGRAM_UPDATE_DATE , CCICV.ITEM_COST , MPIT.PARENT_LPN_ID , MPIT.OUTERMOST_LPN_ID , MPIT.COST_GROUP_ID FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT, MTL_ITEM_LOCATIONS MIL, CST_CG_ITEM_COSTS_VIEW CCICV, MTL_PARAMETERS MP WHERE MPIT.LOCATOR_ID IS NOT NULL AND MIL.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND MIL.INVENTORY_LOCATION_ID = MPIT.LOCATOR_ID AND MIL.PROJECT_ID IS NULL AND CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD, 1, 1, NVL(MPIT.COST_GROUP_ID, 1)) UNION ALL SELECT TAG_ID, PHYSICAL_INVENTORY_ID, MPIT.ORGANIZATION_ID, MPIT.LAST_UPDATE_DATE, MPIT.LAST_UPDATED_BY, MPIT.CREATION_DATE, MPIT.CREATED_BY, MPIT.LAST_UPDATE_LOGIN, VOID_FLAG, TAG_NUMBER , ADJUSTMENT_ID , MPIT.INVENTORY_ITEM_ID, TAG_QUANTITY , TAG_UOM , TAG_QUANTITY_AT_STANDARD_UOM, STANDARD_UOM, SUBINVENTORY, MPIT.LOCATOR_ID, LOT_NUMBER, LOT_EXPIRATION_DATE, REVISION, SERIAL_NUM, COUNTED_BY_EMPLOYEE_ID , LOT_SERIAL_CONTROLS , MPIT.ATTRIBUTE_CATEGORY , MPIT.ATTRIBUTE1, MPIT.ATTRIBUTE2, MPIT.ATTRIBUTE3, MPIT.ATTRIBUTE4, MPIT.ATTRIBUTE5, MPIT.ATTRIBUTE6, MPIT.ATTRIBUTE7, MPIT.ATTRIBUTE8, MPIT.ATTRIBUTE9, MPIT.ATTRIBUTE10, MPIT.ATTRIBUTE11, MPIT.ATTRIBUTE12, MPIT.ATTRIBUTE13, MPIT.ATTRIBUTE14, MPIT.ATTRIBUTE15, MPIT.REQUEST_ID, MPIT.PROGRAM_APPLICATION_ID, MPIT.PROGRAM_ID, MPIT.PROGRAM_UPDATE_DATE , 0 , MPIT.PARENT_LPN_ID , MPIT.OUTERMOST_LPN_ID , MPIT.COST_GROUP_ID FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT, MTL_ITEM_LOCATIONS MIL WHERE MPIT.LOCATOR_ID IS NOT NULL AND MIL.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND MIL.INVENTORY_LOCATION_ID = MPIT.LOCATOR_ID AND MIL.PROJECT_ID IS NULL AND NOT EXISTS (SELECT 'x' FROM CST_CG_ITEM_COSTS_VIEW CCICV, MTL_PARAMETERS MP WHERE CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD, 1, 1, NVL(MPIT.COST_GROUP_ID, 1))) UNION ALL SELECT TAG_ID, PHYSICAL_INVENTORY_ID, MPIT.ORGANIZATION_ID, MPIT.LAST_UPDATE_DATE, MPIT.LAST_UPDATED_BY, MPIT.CREATION_DATE, MPIT.CREATED_BY, MPIT.LAST_UPDATE_LOGIN, VOID_FLAG, TAG_NUMBER , ADJUSTMENT_ID , MPIT.INVENTORY_ITEM_ID, TAG_QUANTITY , TAG_UOM , TAG_QUANTITY_AT_STANDARD_UOM, STANDARD_UOM, SUBINVENTORY, MPIT.LOCATOR_ID, LOT_NUMBER, LOT_EXPIRATION_DATE, REVISION, SERIAL_NUM, COUNTED_BY_EMPLOYEE_ID , LOT_SERIAL_CONTROLS , MPIT.ATTRIBUTE_CATEGORY , MPIT.ATTRIBUTE1, MPIT.ATTRIBUTE2, MPIT.ATTRIBUTE3, MPIT.ATTRIBUTE4, MPIT.ATTRIBUTE5, MPIT.ATTRIBUTE6, MPIT.ATTRIBUTE7, MPIT.ATTRIBUTE8, MPIT.ATTRIBUTE9, MPIT.ATTRIBUTE10, MPIT.ATTRIBUTE11, MPIT.ATTRIBUTE12, MPIT.ATTRIBUTE13, MPIT.ATTRIBUTE14, MPIT.ATTRIBUTE15, MPIT.REQUEST_ID, MPIT.PROGRAM_APPLICATION_ID, MPIT.PROGRAM_ID, MPIT.PROGRAM_UPDATE_DATE , CCICV.ITEM_COST , MPIT.PARENT_LPN_ID , MPIT.OUTERMOST_LPN_ID , MPIT.COST_GROUP_ID FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT, MTL_ITEM_LOCATIONS MIL, MRP_PROJECT_PARAMETERS MRP, CST_CG_ITEM_COSTS_VIEW CCICV, MTL_PARAMETERS MP WHERE MPIT.LOCATOR_ID IS NOT NULL AND MIL.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND MIL.INVENTORY_LOCATION_ID = MPIT.LOCATOR_ID AND MIL.PROJECT_ID IS NOT NULL AND MRP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND MRP.PROJECT_ID = MIL.PROJECT_ID AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID AND CCICV.COST_GROUP_ID =DECODE(MP.PRIMARY_COST_METHOD,1,1, MRP.COSTING_GROUP_ID) UNION ALL SELECT TAG_ID, PHYSICAL_INVENTORY_ID, MPIT.ORGANIZATION_ID, MPIT.LAST_UPDATE_DATE, MPIT.LAST_UPDATED_BY, MPIT.CREATION_DATE, MPIT.CREATED_BY, MPIT.LAST_UPDATE_LOGIN, VOID_FLAG, TAG_NUMBER , ADJUSTMENT_ID , MPIT.INVENTORY_ITEM_ID, TAG_QUANTITY , TAG_UOM , TAG_QUANTITY_AT_STANDARD_UOM, STANDARD_UOM, SUBINVENTORY, MPIT.LOCATOR_ID, LOT_NUMBER, LOT_EXPIRATION_DATE, REVISION, SERIAL_NUM, COUNTED_BY_EMPLOYEE_ID , LOT_SERIAL_CONTROLS , MPIT.ATTRIBUTE_CATEGORY , MPIT.ATTRIBUTE1, MPIT.ATTRIBUTE2, MPIT.ATTRIBUTE3, MPIT.ATTRIBUTE4, MPIT.ATTRIBUTE5, MPIT.ATTRIBUTE6, MPIT.ATTRIBUTE7, MPIT.ATTRIBUTE8, MPIT.ATTRIBUTE9, MPIT.ATTRIBUTE10, MPIT.ATTRIBUTE11, MPIT.ATTRIBUTE12, MPIT.ATTRIBUTE13, MPIT.ATTRIBUTE14, MPIT.ATTRIBUTE15, MPIT.REQUEST_ID, MPIT.PROGRAM_APPLICATION_ID, MPIT.PROGRAM_ID, MPIT.PROGRAM_UPDATE_DATE , 0 , MPIT.PARENT_LPN_ID , MPIT.OUTERMOST_LPN_ID , MPIT.COST_GROUP_ID FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT, MTL_ITEM_LOCATIONS MIL, MRP_PROJECT_PARAMETERS MRP, MTL_PARAMETERS MP WHERE MPIT.LOCATOR_ID IS NOT NULL AND MIL.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND MIL.INVENTORY_LOCATION_ID = MPIT.LOCATOR_ID AND MIL.PROJECT_ID IS NOT NULL AND MRP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND MRP.PROJECT_ID = MIL.PROJECT_ID AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND NOT EXISTS (SELECT 'x' FROM CST_CG_ITEM_COSTS_VIEW CCICV WHERE CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID AND CCICV.COST_GROUP_ID = DECODE(MP.PRIMARY_COST_METHOD,1,1,MRP.COSTING_GROUP_ID))

View Text - HTML Formatted

SELECT TAG_ID
, PHYSICAL_INVENTORY_ID
, MPIT.ORGANIZATION_ID
, MPIT.LAST_UPDATE_DATE
, MPIT.LAST_UPDATED_BY
, MPIT.CREATION_DATE
, MPIT.CREATED_BY
, MPIT.LAST_UPDATE_LOGIN
, VOID_FLAG
, TAG_NUMBER
, ADJUSTMENT_ID
, MPIT.INVENTORY_ITEM_ID
, TAG_QUANTITY
, TAG_UOM
, TAG_QUANTITY_AT_STANDARD_UOM
, STANDARD_UOM
, SUBINVENTORY
, MPIT.LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, REVISION
, SERIAL_NUM
, COUNTED_BY_EMPLOYEE_ID
, LOT_SERIAL_CONTROLS
, MPIT.ATTRIBUTE_CATEGORY
, MPIT.ATTRIBUTE1
, MPIT.ATTRIBUTE2
, MPIT.ATTRIBUTE3
, MPIT.ATTRIBUTE4
, MPIT.ATTRIBUTE5
, MPIT.ATTRIBUTE6
, MPIT.ATTRIBUTE7
, MPIT.ATTRIBUTE8
, MPIT.ATTRIBUTE9
, MPIT.ATTRIBUTE10
, MPIT.ATTRIBUTE11
, MPIT.ATTRIBUTE12
, MPIT.ATTRIBUTE13
, MPIT.ATTRIBUTE14
, MPIT.ATTRIBUTE15
, MPIT.REQUEST_ID
, MPIT.PROGRAM_APPLICATION_ID
, MPIT.PROGRAM_ID
, MPIT.PROGRAM_UPDATE_DATE
, CCICV.ITEM_COST
, MPIT.PARENT_LPN_ID
, MPIT.OUTERMOST_LPN_ID
, MPIT.COST_GROUP_ID
FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT
, CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE MPIT.LOCATOR_ID IS NULL
AND CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MPIT.COST_GROUP_ID
, 1)) UNION ALL SELECT TAG_ID
, PHYSICAL_INVENTORY_ID
, MPIT.ORGANIZATION_ID
, MPIT.LAST_UPDATE_DATE
, MPIT.LAST_UPDATED_BY
, MPIT.CREATION_DATE
, MPIT.CREATED_BY
, MPIT.LAST_UPDATE_LOGIN
, VOID_FLAG
, TAG_NUMBER
, ADJUSTMENT_ID
, MPIT.INVENTORY_ITEM_ID
, TAG_QUANTITY
, TAG_UOM
, TAG_QUANTITY_AT_STANDARD_UOM
, STANDARD_UOM
, SUBINVENTORY
, MPIT.LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, REVISION
, SERIAL_NUM
, COUNTED_BY_EMPLOYEE_ID
, LOT_SERIAL_CONTROLS
, MPIT.ATTRIBUTE_CATEGORY
, MPIT.ATTRIBUTE1
, MPIT.ATTRIBUTE2
, MPIT.ATTRIBUTE3
, MPIT.ATTRIBUTE4
, MPIT.ATTRIBUTE5
, MPIT.ATTRIBUTE6
, MPIT.ATTRIBUTE7
, MPIT.ATTRIBUTE8
, MPIT.ATTRIBUTE9
, MPIT.ATTRIBUTE10
, MPIT.ATTRIBUTE11
, MPIT.ATTRIBUTE12
, MPIT.ATTRIBUTE13
, MPIT.ATTRIBUTE14
, MPIT.ATTRIBUTE15
, MPIT.REQUEST_ID
, MPIT.PROGRAM_APPLICATION_ID
, MPIT.PROGRAM_ID
, MPIT.PROGRAM_UPDATE_DATE
, 0 ITEM_COST
, MPIT.PARENT_LPN_ID
, MPIT.OUTERMOST_LPN_ID
, MPIT.COST_GROUP_ID
FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT
WHERE MPIT.LOCATOR_ID IS NULL
AND NOT EXISTS (SELECT 'X'
FROM CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MPIT.COST_GROUP_ID
, 1))) UNION ALL SELECT TAG_ID
, PHYSICAL_INVENTORY_ID
, MPIT.ORGANIZATION_ID
, MPIT.LAST_UPDATE_DATE
, MPIT.LAST_UPDATED_BY
, MPIT.CREATION_DATE
, MPIT.CREATED_BY
, MPIT.LAST_UPDATE_LOGIN
, VOID_FLAG
, TAG_NUMBER
, ADJUSTMENT_ID
, MPIT.INVENTORY_ITEM_ID
, TAG_QUANTITY
, TAG_UOM
, TAG_QUANTITY_AT_STANDARD_UOM
, STANDARD_UOM
, SUBINVENTORY
, MPIT.LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, REVISION
, SERIAL_NUM
, COUNTED_BY_EMPLOYEE_ID
, LOT_SERIAL_CONTROLS
, MPIT.ATTRIBUTE_CATEGORY
, MPIT.ATTRIBUTE1
, MPIT.ATTRIBUTE2
, MPIT.ATTRIBUTE3
, MPIT.ATTRIBUTE4
, MPIT.ATTRIBUTE5
, MPIT.ATTRIBUTE6
, MPIT.ATTRIBUTE7
, MPIT.ATTRIBUTE8
, MPIT.ATTRIBUTE9
, MPIT.ATTRIBUTE10
, MPIT.ATTRIBUTE11
, MPIT.ATTRIBUTE12
, MPIT.ATTRIBUTE13
, MPIT.ATTRIBUTE14
, MPIT.ATTRIBUTE15
, MPIT.REQUEST_ID
, MPIT.PROGRAM_APPLICATION_ID
, MPIT.PROGRAM_ID
, MPIT.PROGRAM_UPDATE_DATE
, CCICV.ITEM_COST
, MPIT.PARENT_LPN_ID
, MPIT.OUTERMOST_LPN_ID
, MPIT.COST_GROUP_ID
FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT
, MTL_ITEM_LOCATIONS MIL
, CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE MPIT.LOCATOR_ID IS NOT NULL
AND MIL.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID = MPIT.LOCATOR_ID
AND MIL.PROJECT_ID IS NULL
AND CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MPIT.COST_GROUP_ID
, 1)) UNION ALL SELECT TAG_ID
, PHYSICAL_INVENTORY_ID
, MPIT.ORGANIZATION_ID
, MPIT.LAST_UPDATE_DATE
, MPIT.LAST_UPDATED_BY
, MPIT.CREATION_DATE
, MPIT.CREATED_BY
, MPIT.LAST_UPDATE_LOGIN
, VOID_FLAG
, TAG_NUMBER
, ADJUSTMENT_ID
, MPIT.INVENTORY_ITEM_ID
, TAG_QUANTITY
, TAG_UOM
, TAG_QUANTITY_AT_STANDARD_UOM
, STANDARD_UOM
, SUBINVENTORY
, MPIT.LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, REVISION
, SERIAL_NUM
, COUNTED_BY_EMPLOYEE_ID
, LOT_SERIAL_CONTROLS
, MPIT.ATTRIBUTE_CATEGORY
, MPIT.ATTRIBUTE1
, MPIT.ATTRIBUTE2
, MPIT.ATTRIBUTE3
, MPIT.ATTRIBUTE4
, MPIT.ATTRIBUTE5
, MPIT.ATTRIBUTE6
, MPIT.ATTRIBUTE7
, MPIT.ATTRIBUTE8
, MPIT.ATTRIBUTE9
, MPIT.ATTRIBUTE10
, MPIT.ATTRIBUTE11
, MPIT.ATTRIBUTE12
, MPIT.ATTRIBUTE13
, MPIT.ATTRIBUTE14
, MPIT.ATTRIBUTE15
, MPIT.REQUEST_ID
, MPIT.PROGRAM_APPLICATION_ID
, MPIT.PROGRAM_ID
, MPIT.PROGRAM_UPDATE_DATE
, 0
, MPIT.PARENT_LPN_ID
, MPIT.OUTERMOST_LPN_ID
, MPIT.COST_GROUP_ID
FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT
, MTL_ITEM_LOCATIONS MIL
WHERE MPIT.LOCATOR_ID IS NOT NULL
AND MIL.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID = MPIT.LOCATOR_ID
AND MIL.PROJECT_ID IS NULL
AND NOT EXISTS (SELECT 'X'
FROM CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MPIT.COST_GROUP_ID
, 1))) UNION ALL SELECT TAG_ID
, PHYSICAL_INVENTORY_ID
, MPIT.ORGANIZATION_ID
, MPIT.LAST_UPDATE_DATE
, MPIT.LAST_UPDATED_BY
, MPIT.CREATION_DATE
, MPIT.CREATED_BY
, MPIT.LAST_UPDATE_LOGIN
, VOID_FLAG
, TAG_NUMBER
, ADJUSTMENT_ID
, MPIT.INVENTORY_ITEM_ID
, TAG_QUANTITY
, TAG_UOM
, TAG_QUANTITY_AT_STANDARD_UOM
, STANDARD_UOM
, SUBINVENTORY
, MPIT.LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, REVISION
, SERIAL_NUM
, COUNTED_BY_EMPLOYEE_ID
, LOT_SERIAL_CONTROLS
, MPIT.ATTRIBUTE_CATEGORY
, MPIT.ATTRIBUTE1
, MPIT.ATTRIBUTE2
, MPIT.ATTRIBUTE3
, MPIT.ATTRIBUTE4
, MPIT.ATTRIBUTE5
, MPIT.ATTRIBUTE6
, MPIT.ATTRIBUTE7
, MPIT.ATTRIBUTE8
, MPIT.ATTRIBUTE9
, MPIT.ATTRIBUTE10
, MPIT.ATTRIBUTE11
, MPIT.ATTRIBUTE12
, MPIT.ATTRIBUTE13
, MPIT.ATTRIBUTE14
, MPIT.ATTRIBUTE15
, MPIT.REQUEST_ID
, MPIT.PROGRAM_APPLICATION_ID
, MPIT.PROGRAM_ID
, MPIT.PROGRAM_UPDATE_DATE
, CCICV.ITEM_COST
, MPIT.PARENT_LPN_ID
, MPIT.OUTERMOST_LPN_ID
, MPIT.COST_GROUP_ID
FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT
, MTL_ITEM_LOCATIONS MIL
, MRP_PROJECT_PARAMETERS MRP
, CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE MPIT.LOCATOR_ID IS NOT NULL
AND MIL.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID = MPIT.LOCATOR_ID
AND MIL.PROJECT_ID IS NOT NULL
AND MRP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND MRP.PROJECT_ID = MIL.PROJECT_ID
AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID =DECODE(MP.PRIMARY_COST_METHOD
, 1
, 1
, MRP.COSTING_GROUP_ID) UNION ALL SELECT TAG_ID
, PHYSICAL_INVENTORY_ID
, MPIT.ORGANIZATION_ID
, MPIT.LAST_UPDATE_DATE
, MPIT.LAST_UPDATED_BY
, MPIT.CREATION_DATE
, MPIT.CREATED_BY
, MPIT.LAST_UPDATE_LOGIN
, VOID_FLAG
, TAG_NUMBER
, ADJUSTMENT_ID
, MPIT.INVENTORY_ITEM_ID
, TAG_QUANTITY
, TAG_UOM
, TAG_QUANTITY_AT_STANDARD_UOM
, STANDARD_UOM
, SUBINVENTORY
, MPIT.LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, REVISION
, SERIAL_NUM
, COUNTED_BY_EMPLOYEE_ID
, LOT_SERIAL_CONTROLS
, MPIT.ATTRIBUTE_CATEGORY
, MPIT.ATTRIBUTE1
, MPIT.ATTRIBUTE2
, MPIT.ATTRIBUTE3
, MPIT.ATTRIBUTE4
, MPIT.ATTRIBUTE5
, MPIT.ATTRIBUTE6
, MPIT.ATTRIBUTE7
, MPIT.ATTRIBUTE8
, MPIT.ATTRIBUTE9
, MPIT.ATTRIBUTE10
, MPIT.ATTRIBUTE11
, MPIT.ATTRIBUTE12
, MPIT.ATTRIBUTE13
, MPIT.ATTRIBUTE14
, MPIT.ATTRIBUTE15
, MPIT.REQUEST_ID
, MPIT.PROGRAM_APPLICATION_ID
, MPIT.PROGRAM_ID
, MPIT.PROGRAM_UPDATE_DATE
, 0
, MPIT.PARENT_LPN_ID
, MPIT.OUTERMOST_LPN_ID
, MPIT.COST_GROUP_ID
FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT
, MTL_ITEM_LOCATIONS MIL
, MRP_PROJECT_PARAMETERS MRP
, MTL_PARAMETERS MP
WHERE MPIT.LOCATOR_ID IS NOT NULL
AND MIL.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID = MPIT.LOCATOR_ID
AND MIL.PROJECT_ID IS NOT NULL
AND MRP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND MRP.PROJECT_ID = MIL.PROJECT_ID
AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND NOT EXISTS (SELECT 'X'
FROM CST_CG_ITEM_COSTS_VIEW CCICV
WHERE CCICV.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPIT.INVENTORY_ITEM_ID
AND MP.ORGANIZATION_ID = MPIT.ORGANIZATION_ID
AND CCICV.COST_GROUP_ID = DECODE(MP.PRIMARY_COST_METHOD
, 1
, 1
, MRP.COSTING_GROUP_ID))