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.OTFV_FINANCE_HEADERS

Object Details

Object Name:	OTFV_FINANCE_HEADERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OTA.OTFV_FINANCE_HEADERS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows generic financial information about dealings you have with particular customer or supplier.

[View Source]

Columns

Name	Datatype	Length	Comments
HEADER_ID	NUMBER	(9)
HEADER_SUPERSEDES	NUMBER	(9)
FINANCE_HEADER_COMMENTS	VARCHAR2	(2000)	Free Text Comments
DATE_RAISED	DATE
HEADER_TYPE	VARCHAR2	(4000)
HEADER_SUB_TYPE	VARCHAR2	(30)
CANCELLED_FLAG	VARCHAR2	(4000)	An indication of whether has been cancelled
CURRENCY	VARCHAR2	(4000)
ADMINISTRATOR	NUMBER
HEADER_CANCELLED	VARCHAR2	(4000)
HEADER_PAID	VARCHAR2	(4000)
TRANSFER_STATUS	VARCHAR2	(4000)
TRANSFER_DATE	DATE
EXTERNAL_REFERENCE	VARCHAR2	(30)
TRANSFER_MESSAGE	VARCHAR2	(240)
PAYING_COST_CENTER	VARCHAR2	(800)
RECEIVING_COST_CENTER	VARCHAR2	(800)
INVOICE_CONTACT	VARCHAR2	(240)
INVOICE_ADDRESS	VARCHAR2	(2000)
INVOICE_FULL_AMOUNT	VARCHAR2	(4000)
SUPPLIER_NAME	VARCHAR2	(240)
CONTACT_NAME	VARCHAR2	(301)
AUTHORIZED_BY	VARCHAR2	(100)
CUSTOMER_NAME	VARCHAR2	(50)
ORGANIZATION_NAME	VARCHAR2	(240)
ADDRESS_LINE1	VARCHAR2	(240)
ADDRESS_LINE2	VARCHAR2	(240)
ADDRESS_LINE3	VARCHAR2	(240)
ADDRESS_LINE4	VARCHAR2	(560)
CITY	VARCHAR2	(60)
POSTAL_CODE	VARCHAR2	(60)
PROVINCE	VARCHAR2	(60)
COUNTY	VARCHAR2	(60)
SET_OF_BOOKS_FROM	VARCHAR2	(30)
SET_OF_BOOKS_TO	VARCHAR2	(30)
_KF:CODE_COMBINATIONS:FROM	CHAR	(17)
_KF:CODE_COMBINATIONS:TO	CHAR	(18)
_DF	CHAR	(31)
TRANSFER_FROM_SET_OF_BOOKS_ID	NUMBER	(15)
TRANSFER_TO_SET_OF_BOOKS_ID	NUMBER	(15)
TRANSFER_FROM_CC_ID	NUMBER	(15)
TRANSFER_TO_CC_ID	NUMBER	(15)
ADDRESS_ID	NUMBER
APPROVED_BY_ID	NUMBER	(10)
CONTACT_ID	NUMBER	(15)
SUPPLIER_ID	NUMBER	(15)
CUSTOMER_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(9)

Query Text

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


SELECT HEADER_ID
,      HEADER_SUPERSEDES
,      FINANCE_HEADER_COMMENTS
,      DATE_RAISED
,      HEADER_TYPE
,      HEADER_SUB_TYPE
,      CANCELLED_FLAG
,      CURRENCY
,      ADMINISTRATOR
,      HEADER_CANCELLED
,      HEADER_PAID
,      TRANSFER_STATUS
,      TRANSFER_DATE
,      EXTERNAL_REFERENCE
,      TRANSFER_MESSAGE
,      PAYING_COST_CENTER
,      RECEIVING_COST_CENTER
,      INVOICE_CONTACT
,      INVOICE_ADDRESS
,      INVOICE_FULL_AMOUNT
,      SUPPLIER_NAME
,      CONTACT_NAME
,      AUTHORIZED_BY
,      CUSTOMER_NAME
,      ORGANIZATION_NAME
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      POSTAL_CODE
,      PROVINCE
,      COUNTY
,      SET_OF_BOOKS_FROM
,      SET_OF_BOOKS_TO
,      _KF:CODE_COMBINATIONS:FROM
,      _KF:CODE_COMBINATIONS:TO
,      _DF
,      TRANSFER_FROM_SET_OF_BOOKS_ID
,      TRANSFER_TO_SET_OF_BOOKS_ID
,      TRANSFER_FROM_CC_ID
,      TRANSFER_TO_CC_ID
,      ADDRESS_ID
,      APPROVED_BY_ID
,      CONTACT_ID
,      SUPPLIER_ID
,      CUSTOMER_ID
,      ORGANIZATION_ID
FROM APPS.OTFV_FINANCE_HEADERS;

Dependencies

[top of page]

APPS.OTFV_FINANCE_HEADERS references the following:

APPS: FND_GLOBAL - show dependent code; FND_USER; GL_CODE_COMBINATIONS; GL_SETS_OF_BOOKS; HR_ALL_ORGANIZATION_UNITS_TL; HR_BIS - show dependent code; HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_CUST_ACCT_SITES; HZ_LOCATIONS; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_PARTY_SITES; HZ_RELATIONSHIPS; OTA_FINANCE_HEADERS; OTA_GENERAL - show dependent code; OTA_TFH_API_BUSINESS_RULES2 - show dependent code; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.OTFV_FINANCE_HEADERS is not referenced by any database object