VIEW: APPS.OEFV_HOLD_AUTHORIZATIONS

Source

View Text - Preformatted

SELECT AUTH.START_DATE_ACTIVE , AUTH.END_DATE_ACTIVE , '_LA:AUTHORIZED_ACTION_CODE:OE_LOOKUPS:AUTHORIZED_ACTION:MEANING' , '_DF:ONT:OE_HOLD_AUTHORIZATIONS:AUTH','_LA:TYPE_CODE:OE_LOOKUPS:HOLD_TYPE:MEANING', HOLD.NAME, RESP.RESPONSIBILITY_NAME , AUTH.HOLD_ID , AUTH.RESPONSIBILITY_ID , AUTH.APPLICATION_ID, AUTH.LAST_UPDATE_DATE , AUTH.LAST_UPDATED_BY , AUTH.CREATION_DATE , AUTH.CREATED_BY FROM OE_HOLD_AUTHORIZATIONS AUTH , OE_HOLD_DEFINITIONS HOLD , FND_RESPONSIBILITY_TL RESP WHERE AUTH.HOLD_ID = HOLD.HOLD_ID AND AUTH.RESPONSIBILITY_ID = RESP.RESPONSIBILITY_ID(+) AND AUTH.APPLICATION_ID = RESP.APPLICATION_ID(+) AND RESP.LANGUAGE = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT AUTH.START_DATE_ACTIVE
, AUTH.END_DATE_ACTIVE
, '_LA:AUTHORIZED_ACTION_CODE:OE_LOOKUPS:AUTHORIZED_ACTION:MEANING'
, '_DF:ONT:OE_HOLD_AUTHORIZATIONS:AUTH'
, '_LA:TYPE_CODE:OE_LOOKUPS:HOLD_TYPE:MEANING'
, HOLD.NAME
, RESP.RESPONSIBILITY_NAME
, AUTH.HOLD_ID
, AUTH.RESPONSIBILITY_ID
, AUTH.APPLICATION_ID
, AUTH.LAST_UPDATE_DATE
, AUTH.LAST_UPDATED_BY
, AUTH.CREATION_DATE
, AUTH.CREATED_BY
FROM OE_HOLD_AUTHORIZATIONS AUTH
, OE_HOLD_DEFINITIONS HOLD
, FND_RESPONSIBILITY_TL RESP
WHERE AUTH.HOLD_ID = HOLD.HOLD_ID
AND AUTH.RESPONSIBILITY_ID = RESP.RESPONSIBILITY_ID(+)
AND AUTH.APPLICATION_ID = RESP.APPLICATION_ID(+)
AND RESP.LANGUAGE = USERENV('LANG') WITH READ ONLY