View: FV_SYSTEM_PARAMETERS_V

Product:	FV - Federal Financials
Description:	Stores system information used by processes such as Prompt Payment and FMS Form 224 Statement ofTransactions and by disbursements in transit accounting; one row for each Set of Books defined in the system
Implementation/DBA Data:	APPS.FV_SYSTEM_PARAMETERS_V

View Text

SELECT OU.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, LEP.NAME NAME
, L.ADDRESS_LINE_1 ADDRESS_LINE_1
, L.ADDRESS_LINE_2 ADDRESS_LINE_2
, L.ADDRESS_LINE_3 ADDRESS_LINE_3
, L.TOWN_OR_CITY TOWN_OR_CITY
, L.REGION_1 REGION_1
, L.REGION_2 REGION_2
, L.REGION_3 REGIOND_3
, L.POSTAL_CODE POSTAL_CODE
, OU.ORG_ID OU_ORG_ID
, OU.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, OU.ALC_CODE ALC_CODE
, OU.RECEIVABLES_TRX_ID RECEIVABLES_TRX_ID
, OU.PAYABLES_IA_PAYGROUP PAYABLES_IA_PAYGROUP
, L.TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1
, L.TELEPHONE_NUMBER_2 TELEPHONE_NUMBER_2
, L.TELEPHONE_NUMBER_3 TELEPHONE_NUMBER_3
, OU.FED_EMPLOYER_ID_NUMBER FED_EMPLOYER_ID_NUMBER
, OU.DIT_CONFIRM_CASH_ACCOUNT DIT_CONFIRM_CASH_ACCOUNT
FROM FV_OPERATING_UNITS OU
, XLE_FIRSTPARTY_INFORMATION_V LEP
, HR_LOCATIONS L
WHERE LEP.LEGAL_ENTITY_ID = OU.LEGAL_ENTITY_ID
AND LEP.LOCATION_ID = L.LOCATION_ID

Columns