eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MTL_PHY_INV_TAGS_COST_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_PHY_INV_TAGS_COST_V

View Text

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))

Columns

Name
TAG_ID
PHYSICAL_INVENTORY_ID
ORGANIZATION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
VOID_FLAG
TAG_NUMBER
ADJUSTMENT_ID
INVENTORY_ITEM_ID
TAG_QUANTITY
TAG_UOM
TAG_QUANTITY_AT_STANDARD_UOM
STANDARD_UOM
SUBINVENTORY
LOCATOR_ID
LOT_NUMBER
LOT_EXPIRATION_DATE
REVISION
SERIAL_NUM
COUNTED_BY_EMPLOYEE_ID
LOT_SERIAL_CONTROLS
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ITEM_COST
PARENT_LPN_ID
OUTERMOST_LPN_ID
COST_GROUP_ID