Product: | INV - Inventory |
---|---|
Description: | View based on table MTL_PHYSICAL_INVENTORIES. Has all the Physical Inventory Setup Information. |
Implementation/DBA Data: | APPS.MTL_PHYSICAL_INVENTORIES_V |
SELECT M.ROWID ROW_ID
, M.ORGANIZATION_ID
, M.PHYSICAL_INVENTORY_ID
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.PHYSICAL_INVENTORY_DATE
, M.LAST_ADJUSTMENT_DATE
, M.TOTAL_ADJUSTMENT_VALUE
, M.DESCRIPTION
, M.FREEZE_DATE
, M.PHYSICAL_INVENTORY_NAME
, M.APPROVAL_REQUIRED
, M.ALL_SUBINVENTORIES_FLAG
, DECODE (M.FREEZE_DATE
, NULL
, 2
, 1 ) SNAPSHOT_COMPLETE
, DECODE (M.LAST_ADJUSTMENT_DATE
, NULL
, 2
, 1 ) ADJUSTMENTS_POSTED
, M.NEXT_TAG_NUMBER
, M.TAG_NUMBER_INCREMENTS
, M.DEFAULT_GL_ADJUST_ACCOUNT
, M.APPROVAL_TOLERANCE_POS
, M.APPROVAL_TOLERANCE_NEG
, M.COST_VARIANCE_POS
, M.COST_VARIANCE_NEG
, M.NUMBER_OF_SKUS
, M.DYNAMIC_TAG_ENTRY_FLAG
, M.REQUEST_ID
, M.PROGRAM_APPLICATION_ID
, M.PROGRAM_ID
, M.PROGRAM_UPDATE_DATE
, M.ATTRIBUTE_CATEGORY
, M.ATTRIBUTE1
, M.ATTRIBUTE2
, M.ATTRIBUTE3
, M.ATTRIBUTE4
, M.ATTRIBUTE5
, M.ATTRIBUTE6
, M.ATTRIBUTE7
, M.ATTRIBUTE8
, M.ATTRIBUTE9
, M.ATTRIBUTE10
, M.ATTRIBUTE11
, M.ATTRIBUTE12
, M.ATTRIBUTE13
, M.ATTRIBUTE14
, M.ATTRIBUTE15
, M.EXCLUDE_ZERO_BALANCE
, M.EXCLUDE_NEGATIVE_BALANCE
FROM MTL_PHYSICAL_INVENTORIES M