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]

TABLE: FV.FV_SF1080_HEADER_TEMP

Object Details

Object Name:	FV_SF1080_HEADER_TEMP
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_SF1080_HEADER_TEMP
Subobject Name:
Status:	VALID

FV_SF1080_HEADER_TEMP stores transaction information from RA_CUSTOMER_TRX, HZ_CUST_ACCOUNTS, HZ_PARTIES and HZ_LOCATIONS that has been selected based on the parameters passed for generation of the SF 1080 Voucher for Transfers Between Appropriations or Funds document.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Invoice identifier
TRX_NUMBER	VARCHAR2	(20)	Yes	Transaction number
CUSTOMER_NAME	VARCHAR2	(360)	Yes	Customer name
CUST_ADDRESS1	VARCHAR2	(240)	Yes	First line of customer address
REMIT_TO_ADDRESS_ADDRESS1	VARCHAR2	(240)	Yes	First line of remit to address
CUST_ADDRESS2	VARCHAR2	(240)		Second line of customer address
CUST_ADDRESS3	VARCHAR2	(240)		Third line of customer address
CUST_ADDRESS4	VARCHAR2	(240)		Fourth line of customer address
CUST_CITY	VARCHAR2	(60)		City
CUST_STATE	VARCHAR2	(60)		State
CUST_POSTAL_CODE	VARCHAR2	(60)		Postal code
REMIT_TO_ADDRESS_ADDRESS2	VARCHAR2	(240)		Second line of remit to address
REMIT_TO_ADDRESS_ADDRESS3	VARCHAR2	(240)		Third line of remit to address
REMIT_TO_ADDRESS_ADDRESS4	VARCHAR2	(240)		Fourth line of remit to address
REMIT_TO_ADDRESS_CITY	VARCHAR2	(60)		Remit to city
REMIT_TO_ADDRESS_STATE	VARCHAR2	(60)		Remit to state
REMIT_TO_ADDRESS_POSTAL_CODE	VARCHAR2	(60)		Remit to postal code
ACCT_OFC_CHRG	VARCHAR2	(50)		Accounting information for office being charged

Query Text

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


SELECT CUSTOMER_TRX_ID
,      TRX_NUMBER
,      CUSTOMER_NAME
,      CUST_ADDRESS1
,      REMIT_TO_ADDRESS_ADDRESS1
,      CUST_ADDRESS2
,      CUST_ADDRESS3
,      CUST_ADDRESS4
,      CUST_CITY
,      CUST_STATE
,      CUST_POSTAL_CODE
,      REMIT_TO_ADDRESS_ADDRESS2
,      REMIT_TO_ADDRESS_ADDRESS3
,      REMIT_TO_ADDRESS_ADDRESS4
,      REMIT_TO_ADDRESS_CITY
,      REMIT_TO_ADDRESS_STATE
,      REMIT_TO_ADDRESS_POSTAL_CODE
,      ACCT_OFC_CHRG
FROM FV.FV_SF1080_HEADER_TEMP;

Dependencies

[top of page]

FV.FV_SF1080_HEADER_TEMP does not reference any database object

FV.FV_SF1080_HEADER_TEMP is referenced by following:

APPS: FV_SF1080_HEADER_TEMP