[Home] [Help]
View: INVFV_MOVE_ORDERS_HEADERS
View Text
SELECT TRH.HEADER_ID
, TRH.REQUEST_NUMBER
, TRH.TRANSACTION_TYPE_ID
, MTT.TRANSACTION_TYPE_NAME
, TRH.ORGANIZATION_ID
, HOU.NAME
, TRH.DESCRIPTION
, TRH.DATE_REQUIRED
, TRH.FROM_SUBINVENTORY_CODE
, TRH.TO_SUBINVENTORY_CODE
, TRH.TO_ACCOUNT_ID
, '_KF:SQLGL:GL#:GLC'
, '_LA:TRH.HEADER_STATUS:MFG_LOOKUPS:MTL_TXN_REQUEST_STATUS:MEANING'
, TRH.STATUS_DATE
, TRH.CREATED_BY
, TRH.CREATION_DATE
, TRH.LAST_UPDATED_BY
, TRH.LAST_UPDATE_DATE
FROM HR_ALL_ORGANIZATION_UNITS HOU
, MTL_TRANSACTION_TYPES MTT
, GL_CODE_COMBINATIONS GLC
, MTL_TXN_REQUEST_HEADERS TRH
WHERE HOU.ORGANIZATION_ID = TRH.ORGANIZATION_ID
AND MTT.TRANSACTION_TYPE_ID = TRH.TRANSACTION_TYPE_ID
AND GLC.CODE_COMBINATION_ID (+)= TRH.TO_ACCOUNT_ID
AND '_SEC:TRH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
| HEADER_ID |
| REQUEST_NUMBER |
| TRANSACTION_TYPE_ID |
| TRANSACTION_TYPE_NAME |
| ORGANIZATION_ID |
| ORGANIZATION_NAME |
| DESCRIPTION |
| DATE_REQUIRED |
| FROM_SUBINVENTORY_CODE |
| TO_SUBINVENTORY_CODE |
| TO_ACCOUNT_ID |
| "_KF:ACC_NO:TO_ACCOUNT:_CO" |
| "_LA:HEADER_STATUS" |
| STATUS_DATE |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| Name |
APPS.INVFV_MOVE_ORDERS_HEADERS