SELECT TRH.HEADER_ID , TRH.REQUEST_NUMBER , TRH.TRANSACTION_TYPE_ID , TRH.ORGANIZATION_ID , TRH.DESCRIPTION , TRH.DATE_REQUIRED , TRH.FROM_SUBINVENTORY_CODE , TRH.TO_SUBINVENTORY_CODE , TRH.TO_ACCOUNT_ID , '_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 MTL_TXN_REQUEST_HEADERS TRH where '_SEC:TRH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
SELECT TRH.HEADER_ID
, TRH.REQUEST_NUMBER
, TRH.TRANSACTION_TYPE_ID
, TRH.ORGANIZATION_ID
, TRH.DESCRIPTION
, TRH.DATE_REQUIRED
, TRH.FROM_SUBINVENTORY_CODE
, TRH.TO_SUBINVENTORY_CODE
, TRH.TO_ACCOUNT_ID
, '_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 MTL_TXN_REQUEST_HEADERS TRH
WHERE '_SEC:TRH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
|
|
|