VIEW: APPS.INVFV_MOVE_ORDERS_HEADERS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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