View: MTL_PHY_ADJ_COST_V

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

View Text

SELECT MPA.ADJUSTMENT_ID
, MPA.ORGANIZATION_ID
, MPA.PHYSICAL_INVENTORY_ID
, MPA.INVENTORY_ITEM_ID
, MPA.SUBINVENTORY_NAME
, MPA.SYSTEM_QUANTITY
, MPA.LAST_UPDATE_DATE
, MPA.LAST_UPDATED_BY
, MPA.CREATION_DATE
, MPA.CREATED_BY
, MPA.LAST_UPDATE_LOGIN
, MPA.COUNT_QUANTITY
, ADJUSTMENT_QUANTITY
, REVISION
, MPA.LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, SERIAL_NUMBER
, ACTUAL_COST
, APPROVAL_STATUS
, APPROVED_BY_EMPLOYEE_ID
, AUTOMATIC_APPROVAL_CODE
, GL_ADJUST_ACCOUNT
, MPA.REQUEST_ID
, MPA.PROGRAM_APPLICATION_ID
, MPA.PROGRAM_ID
, MPA.PROGRAM_UPDATE_DATE
, LOT_SERIAL_CONTROLS
, TEMP_APPROVER
, CCICV.ITEM_COST
, MPA.PARENT_LPN_ID
, MPA.OUTERMOST_LPN_ID
, MPA.COST_GROUP_ID
FROM MTL_PHYSICAL_ADJUSTMENTS MPA
, CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE MPA.LOCATOR_ID IS NULL
AND MP.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND CCICV.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPA.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MPA.COST_GROUP_ID
, 1)) UNION ALL SELECT MPA.ADJUSTMENT_ID
, MPA.ORGANIZATION_ID
, MPA.PHYSICAL_INVENTORY_ID
, MPA.INVENTORY_ITEM_ID
, MPA.SUBINVENTORY_NAME
, MPA.SYSTEM_QUANTITY
, MPA.LAST_UPDATE_DATE
, MPA.LAST_UPDATED_BY
, MPA.CREATION_DATE
, MPA.CREATED_BY
, MPA.LAST_UPDATE_LOGIN
, MPA.COUNT_QUANTITY
, ADJUSTMENT_QUANTITY
, REVISION
, MPA.LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, SERIAL_NUMBER
, ACTUAL_COST
, APPROVAL_STATUS
, APPROVED_BY_EMPLOYEE_ID
, AUTOMATIC_APPROVAL_CODE
, GL_ADJUST_ACCOUNT
, MPA.REQUEST_ID
, MPA.PROGRAM_APPLICATION_ID
, MPA.PROGRAM_ID
, MPA.PROGRAM_UPDATE_DATE
, LOT_SERIAL_CONTROLS
, TEMP_APPROVER
, 0 ITEM_COST
, MPA.PARENT_LPN_ID
, MPA.OUTERMOST_LPN_ID
, MPA.COST_GROUP_ID
FROM MTL_PHYSICAL_ADJUSTMENTS MPA
WHERE MPA.LOCATOR_ID IS NULL
AND NOT EXISTS (SELECT 'X'
FROM CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE CCICV.ORGANIZATION_ID = MPA.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPA.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MPA.COST_GROUP_ID
, 1))) UNION ALL SELECT MPA.ADJUSTMENT_ID
, MPA.ORGANIZATION_ID
, MPA.PHYSICAL_INVENTORY_ID
, MPA.INVENTORY_ITEM_ID
, MPA.SUBINVENTORY_NAME
, MPA.SYSTEM_QUANTITY
, MPA.LAST_UPDATE_DATE
, MPA.LAST_UPDATED_BY
, MPA.CREATION_DATE
, MPA.CREATED_BY
, MPA.LAST_UPDATE_LOGIN
, MPA.COUNT_QUANTITY
, ADJUSTMENT_QUANTITY
, REVISION
, MPA.LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, SERIAL_NUMBER
, ACTUAL_COST
, APPROVAL_STATUS
, APPROVED_BY_EMPLOYEE_ID
, AUTOMATIC_APPROVAL_CODE
, GL_ADJUST_ACCOUNT
, MPA.REQUEST_ID
, MPA.PROGRAM_APPLICATION_ID
, MPA.PROGRAM_ID
, MPA.PROGRAM_UPDATE_DATE
, LOT_SERIAL_CONTROLS
, TEMP_APPROVER
, CCICV.ITEM_COST
, MPA.PARENT_LPN_ID
, MPA.OUTERMOST_LPN_ID
, MPA.COST_GROUP_ID
FROM MTL_PHYSICAL_ADJUSTMENTS MPA
, MTL_ITEM_LOCATIONS MIL
, CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE MPA.LOCATOR_ID IS NOT NULL
AND MIL.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID = MPA.LOCATOR_ID
AND MIL.PROJECT_ID IS NULL
AND CCICV.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPA.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MPA.COST_GROUP_ID
, 1)) UNION ALL SELECT MPA.ADJUSTMENT_ID
, MPA.ORGANIZATION_ID
, MPA.PHYSICAL_INVENTORY_ID
, MPA.INVENTORY_ITEM_ID
, MPA.SUBINVENTORY_NAME
, MPA.SYSTEM_QUANTITY
, MPA.LAST_UPDATE_DATE
, MPA.LAST_UPDATED_BY
, MPA.CREATION_DATE
, MPA.CREATED_BY
, MPA.LAST_UPDATE_LOGIN
, MPA.COUNT_QUANTITY
, ADJUSTMENT_QUANTITY
, REVISION
, MPA.OUTERMOST_LPN_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, SERIAL_NUMBER
, ACTUAL_COST
, APPROVAL_STATUS
, APPROVED_BY_EMPLOYEE_ID
, AUTOMATIC_APPROVAL_CODE
, GL_ADJUST_ACCOUNT
, MPA.REQUEST_ID
, MPA.PROGRAM_APPLICATION_ID
, MPA.PROGRAM_ID
, MPA.PROGRAM_UPDATE_DATE
, LOT_SERIAL_CONTROLS
, TEMP_APPROVER
, 0
, MPA.PARENT_LPN_ID
, MPA.OUTERMOST_LPN_ID
, MPA.COST_GROUP_ID
FROM MTL_PHYSICAL_ADJUSTMENTS MPA
, MTL_ITEM_LOCATIONS MIL
WHERE MPA.LOCATOR_ID IS NOT NULL
AND MIL.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID = MPA.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 = MPA.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPA.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MPA.COST_GROUP_ID
, 1))) UNION ALL SELECT MPA.ADJUSTMENT_ID
, MPA.ORGANIZATION_ID
, MPA.PHYSICAL_INVENTORY_ID
, MPA.INVENTORY_ITEM_ID
, MPA.SUBINVENTORY_NAME
, MPA.SYSTEM_QUANTITY
, MPA.LAST_UPDATE_DATE
, MPA.LAST_UPDATED_BY
, MPA.CREATION_DATE
, MPA.CREATED_BY
, MPA.LAST_UPDATE_LOGIN
, MPA.COUNT_QUANTITY
, ADJUSTMENT_QUANTITY
, REVISION
, MPA.LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, SERIAL_NUMBER
, ACTUAL_COST
, APPROVAL_STATUS
, APPROVED_BY_EMPLOYEE_ID
, AUTOMATIC_APPROVAL_CODE
, GL_ADJUST_ACCOUNT
, MPA.REQUEST_ID
, MPA.PROGRAM_APPLICATION_ID
, MPA.PROGRAM_ID
, MPA.PROGRAM_UPDATE_DATE
, LOT_SERIAL_CONTROLS
, TEMP_APPROVER
, CCICV.ITEM_COST
, MPA.PARENT_LPN_ID
, MPA.OUTERMOST_LPN_ID
, MPA.COST_GROUP_ID
FROM MTL_PHYSICAL_ADJUSTMENTS MPA
, MTL_ITEM_LOCATIONS MIL
, MRP_PROJECT_PARAMETERS MRP
, CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE MPA.LOCATOR_ID IS NOT NULL
AND MIL.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID = MPA.LOCATOR_ID
AND MIL.PROJECT_ID IS NOT NULL
AND MRP.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND MRP.PROJECT_ID = MIL.PROJECT_ID
AND CCICV.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPA.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = DECODE(MP.PRIMARY_COST_METHOD
, 1
, 1
, MRP.COSTING_GROUP_ID) UNION ALL SELECT MPA.ADJUSTMENT_ID
, MPA.ORGANIZATION_ID
, MPA.PHYSICAL_INVENTORY_ID
, MPA.INVENTORY_ITEM_ID
, MPA.SUBINVENTORY_NAME
, MPA.SYSTEM_QUANTITY
, MPA.LAST_UPDATE_DATE
, MPA.LAST_UPDATED_BY
, MPA.CREATION_DATE
, MPA.CREATED_BY
, MPA.LAST_UPDATE_LOGIN
, MPA.COUNT_QUANTITY
, ADJUSTMENT_QUANTITY
, REVISION
, MPA.LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, SERIAL_NUMBER
, ACTUAL_COST
, APPROVAL_STATUS
, APPROVED_BY_EMPLOYEE_ID
, AUTOMATIC_APPROVAL_CODE
, GL_ADJUST_ACCOUNT
, MPA.REQUEST_ID
, MPA.PROGRAM_APPLICATION_ID
, MPA.PROGRAM_ID
, MPA.PROGRAM_UPDATE_DATE
, LOT_SERIAL_CONTROLS
, TEMP_APPROVER
, 0
, MPA.PARENT_LPN_ID
, MPA.OUTERMOST_LPN_ID
, MPA.COST_GROUP_ID
FROM MTL_PHYSICAL_ADJUSTMENTS MPA
, MTL_ITEM_LOCATIONS MIL
, MRP_PROJECT_PARAMETERS MRP
, MTL_PARAMETERS MP
WHERE MPA.LOCATOR_ID IS NOT NULL
AND MIL.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID = MPA.LOCATOR_ID
AND MIL.PROJECT_ID IS NOT NULL
AND MRP.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND MRP.PROJECT_ID = MIL.PROJECT_ID
AND NOT EXISTS (SELECT 'X'
FROM CST_CG_ITEM_COSTS_VIEW CCICV
WHERE CCICV.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MPA.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = MPA.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = DECODE(MP.PRIMARY_COST_METHOD
, 1
, 1
, MRP.COSTING_GROUP_ID))

Columns