VIEW: APPS.MTL_PHYSICAL_INVENTORIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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