FND Design Data [Home] [Help]

View: FV_AGENCY_LOCATION_CODES_V

Product: FV - Federal Financials
Description: FV_AGENCY_LOCATION_CODES_V is based on the table Ap_Bank_Accounts_All.
Implementation/DBA Data: ViewAPPS.FV_AGENCY_LOCATION_CODES_V
View Text

SELECT DISTINCT AGENCY_LOCATION_CODE
, SET_OF_BOOKS_ID
, ORG_ID
FROM AP_BANK_ACCOUNTS_ALL
WHERE AGENCY_LOCATION_CODE IS NOT NULL
AND ACCOUNT_TYPE = 'INTERNAL' UNION SELECT 'ALL'
, -1 SET_OF_BOOKS_ID
, -1 ORG_ID
FROM DUAL

Columns

Name
AGENCY_LOCATION_CODE
SET_OF_BOOKS_ID
ORG_ID