[Home] [Help]
View: APFV_AP_HOLDS
Product: | AP - Payables |
Description: | Business view |
Implementation/DBA Data: |
APPS.APFV_AP_HOLDS
|
View Text
SELECT HO.HELD_BY
, HO.HOLD_DATE
, HO.HOLD_REASON
, '_LA:HO.HOLD_LOOKUP_CODE:AP_LOOKUP_CODES:HOLD CODE:DESCRIPTION'
, HO.RELEASE_REASON
, '_LA:HO.RELEASE_LOOKUP_CODE:AP_LOOKUP_CODES:HOLD CODE:DESCRIPTION'
, HO.RESPONSIBILITY_ID
, HO.INVOICE_ID
, HO.LINE_LOCATION_ID
, HO.HOLD_LOOKUP_CODE
, '_DF:SQLAP:AP_HOLDS:HO'
, HO.CREATION_DATE
, HO.CREATED_BY
, HO.LAST_UPDATE_DATE
, HO.LAST_UPDATED_BY
FROM AP_HOLDS HO WITH READ ONLY
Columns
Name |
HELD_BY_USER_ID |
HOLD_DATE |
HOLD_REASON |
"_LA:HOLD_DESCRIPTION" |
HOLD_RELEASE_REASON |
"_LA:RELEASE_DESCRIPTION" |
INSUFFICIENT_FUNDS_OWNER_ID |
INVOICE_ID |
LINE_LOCATION_ID |
HOLD_CODE |
_DF |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |