View: MTL_MOVE_ORDER_HEADERS_V

View Text

SELECT MMOH.MOVE_ORDER_HEADER_ID MOVE_ORDER_HEADER_ID
, MMOH.MOVE_ORDER_NUMBER MOVE_ORDER_NUMBER
, MMOH.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME
, MTT.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, MMOH.ORGANIZATION_ID ORGANIZATION_ID
, MMOH.DESCRIPTION DESCRIPTION
, MMOH.DEFAULT_DATE_REQUIRED DEFAULT_DATE_REQUIRED
, MMOH.DEFAULT_FROM_SUBINVENTORY_CODE DEFAULT_FROM_SUBINVENTORY_CODE
, MMOH.DEFAULT_TO_SUBINVENTORY_CODE DEFAULT_TO_SUBINVENTORY_CODE
, MMOH.DEFAULT_TO_ACCOUNT_ID DEFAULT_TO_ACCOUNT_ID
, MMOH.HEADER_STATUS HEADER_STATUS
, MMOH.STATUS_DATE STATUS_DATE
, MMOH.HEADER_APPROVAL_STATUS HEADER_APPROVAL_STATUS
, MMOH.APPROVAL_DATE APPROVAL_DATE
, MMOH.LAST_UPDATED_BY LAST_UPDATED_BY
, MMOH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MMOH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MMOH.CREATED_BY CREATED_BY
, MMOH.CREATION_DATE CREATION_DATE
, MMOH.REQUEST_ID REQUEST_ID
, MMOH.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MMOH.PROGRAM_ID PROGRAM_ID
, MMOH.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MMOH.ATTRIBUTE1 ATTRIBUTE1
, MMOH.ATTRIBUTE2 ATTRIBUTE2
, MMOH.ATTRIBUTE3 ATTRIBUTE3
, MMOH.ATTRIBUTE4 ATTRIBUTE4
, MMOH.ATTRIBUTE5 ATTRIBUTE5
, MMOH.ATTRIBUTE6 ATTRIBUTE6
, MMOH.ATTRIBUTE7 ATTRIBUTE7
, MMOH.ATTRIBUTE8 ATTRIBUTE8
, MMOH.ATTRIBUTE9 ATTRIBUTE9
, MMOH.ATTRIBUTE10 ATTRIBUTE10
, MMOH.ATTRIBUTE11 ATTRIBUTE11
, MMOH.ATTRIBUTE12 ATTRIBUTE12
, MMOH.ATTRIBUTE13 ATTRIBUTE13
, MMOH.ATTRIBUTE14 ATTRIBUTE14
, MMOH.ATTRIBUTE15 ATTRIBUTE15
, MMOH.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
FROM MTL_MOVE_ORDER_HEADERS MMOH
, MTL_TRANSACTION_TYPES MTT
, MFG_LOOKUPS MFG1
, MFG_LOOKUPS MFG2
WHERE MTT.TRANSACTION_TYPE_ID = MMOH.TRANSACTION_TYPE_ID
AND MFG1.LOOKUP_TYPE = 'MTL_MO_HEADER_APPROVAL_STATUS'
AND MFG1.LOOKUP_CODE = MMOH.HEADER_APPROVAL_STATUS
AND MFG1.LOOKUP_TYPE = 'MTL_MO_HEADER_STATUS'
AND MFG2.LOOKUP_CODE = MMOH.HEADER_STATUS

Columns