eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.FV_SYSTEM_PARAMETERS_V

Object Details

Object Name:	FV_SYSTEM_PARAMETERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FV.FV_SYSTEM_PARAMETERS_V
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

FV_SYSTEM_PARAMETERS_V stores system information used by
processes such as Prompt Payment and FMS Form 224 Statement of
Transactions, and by disbursements in transit accounting. There is
one row for each Set of Books defined in the system.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
NAME	VARCHAR2	(240)	Yes	Legal entity name
ADDRESS_LINE_1	VARCHAR2	(240)		Legal entity address
ADDRESS_LINE_2	VARCHAR2	(240)		Legal entity address
ADDRESS_LINE_3	VARCHAR2	(240)		Legal entity address
TOWN_OR_CITY	VARCHAR2	(30)		Legal entity city
REGION_1	VARCHAR2	(120)
REGION_2	VARCHAR2	(120)		Legal entity state
REGION_3	VARCHAR2	(120)
POSTAL_CODE	VARCHAR2	(30)		Legal entity postal code
OU_ORG_ID	NUMBER	(15)	Yes	Operating unit organization identifier
LEGAL_ENTITY_ID	NUMBER	(15)	Yes
ALC_CODE	VARCHAR2	(30)		Agency Location Code
RECEIVABLES_TRX_ID	NUMBER	(15)		Receivables Transaction ID
PAYABLES_IA_PAYGROUP	VARCHAR2	(30)	Yes	Interagency Pay Group
TELEPHONE_NUMBER_1	VARCHAR2	(60)
TELEPHONE_NUMBER_2	VARCHAR2	(60)
TELEPHONE_NUMBER_3	VARCHAR2	(60)
FED_EMPLOYER_ID_NUMBER	VARCHAR2	(20)		Federal Employer Identification Number enetered in Define Federal Options window.
DIT_CONFIRM_CASH_ACCOUNT	VARCHAR2	(25)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SET_OF_BOOKS_ID
,      NAME
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      REGION_1
,      REGION_2
,      REGION_3
,      POSTAL_CODE
,      OU_ORG_ID
,      LEGAL_ENTITY_ID
,      ALC_CODE
,      RECEIVABLES_TRX_ID
,      PAYABLES_IA_PAYGROUP
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      FED_EMPLOYER_ID_NUMBER
,      DIT_CONFIRM_CASH_ACCOUNT
FROM APPS.FV_SYSTEM_PARAMETERS_V;

Dependencies

[top of page]

APPS.FV_SYSTEM_PARAMETERS_V references the following:

APPS: FV_OPERATING_UNITS; HR_GENERAL - show dependent code; HR_LOCATIONS; XLE_FIRSTPARTY_INFORMATION_V

APPS.FV_SYSTEM_PARAMETERS_V is referenced by following:

APPS: FV_SF224_TRANSACTIONS - show dependent code; IBY_PAYMENT_FORMAT_VAL_PVT - show dependent code