VIEW: APPS.FV_SYSTEM_PARAMETERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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