[Home] [Help]
View: OEFV_ORDER_HOLD_AUTHORIZATIONS
| Product: | OE - Order Entry |
|---|
| Description: | - Retrofitted |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT '_LA:AUTHORIZED_ACTION_CODE:SO_LOOKUPS:AUTHORIZED_ACTION:MEANING'
, AUTH.START_DATE_ACTIVE
, AUTH.END_DATE_ACTIVE
, '_DF:OE:SO_HOLD_AUTHORIZATIONS:AUTH'
, '_LA:TYPE_CODE:SO_LOOKUPS:HOLD_TYPE:MEANING'
, 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 SO_HOLD_AUTHORIZATIONS AUTH
, SO_HOLDS HOLD
, FND_RESPONSIBILITY_VL RESP
WHERE AUTH.HOLD_ID = HOLD.HOLD_ID
AND AUTH.RESPONSIBILITY_ID = RESP.RESPONSIBILITY_ID
AND AUTH.APPLICATION_ID = RESP.APPLICATION_ID WITH READ ONLY
Columns
| Name |
| "_LA:AUTHORIZED_ACTION" |
| START_DATE |
| END_DATE |
| "_DF" |
| "_LA:HOLD_TYPE" |
| RESPONSIBILITY_NAME |
| HOLD_ID |
| RESPONSIBILITY_ID |
| APPLICATION_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |