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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORIGINAL_COPY	VARCHAR2	(8)
CUST_ACCOUNT_ID	NUMBER	(15)	Yes
PARTY_ID	NUMBER	(15)	Yes
PARTY_SITE_ID	NUMBER	(15)	Yes
CUST_ACCT_SITE_ID	NUMBER	(15)	Yes
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes
ACCOUNT_NAME	VARCHAR2	(240)
CUSTOMER_PARTY_NAME	VARCHAR2	(360)	Yes
CUSTOMER_TAX_REFERENCE	VARCHAR2	(50)
CUSTOMER_TAX_PAYER_ID	VARCHAR2	(20)
CUSTOMER_TAX_REF_NUMBER	VARCHAR2	(50)
REP_REG_NUMBER	VARCHAR2	(50)
RECEIPT_METHOD_NAME	VARCHAR2	(30)
PAYMENT_METHOD_NAME	VARCHAR2	(100)
CUSTOMER_ADDRESS	VARCHAR2	(963)
CUSTOMER_CITY	VARCHAR2	(60)
CUSTOMER_STATE	VARCHAR2	(60)
CUSTOMER_COUNTY	VARCHAR2	(60)
CUSTOMER_POSTAL_CODE	VARCHAR2	(60)
CUSTOMER_COMPLETE_ADDRESS	VARCHAR2	(1207)
CUSTOMER_ATTR_COMPLETE_ADDRESS	VARCHAR2	(301)
CUSTOMER_NAME_ATTR	VARCHAR2	(150)
CUSTOMER_ADDRESS_ATTR	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE3	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE4	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE5	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE6	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE7	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE8	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE9	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE10	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE11	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE12	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE13	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE14	VARCHAR2	(150)
RCT_GLOBAL_ATTRIBUTE15	VARCHAR2	(150)
TRANSACTION_ID	NUMBER	(15)	Yes
TRANSACTION_NUMBER	VARCHAR2	(20)	Yes
TRANSACTION_DATE	DATE		Yes
TRANSACTION_TERM_DUE_DATE	DATE
TRANSACTION_CURRENCY_CODE	VARCHAR2	(15)
DOCUMENT_SEQUENCE_NUMBER	NUMBER	(15)
WAYBILL_NUMBER	VARCHAR2	(50)
TRANSACTION_TYPE	VARCHAR2	(20)
SHIPPING_BILL	VARCHAR2	(150)
SHIPPING_DATE	DATE
VENDOR_PARTY_NAME	VARCHAR2	(360)	Yes
VENDOR_ADDRESS	VARCHAR2	(240)
VENDOR_CITY	VARCHAR2	(60)
VENDOR_STATE	VARCHAR2	(60)
VENDOR_COUNTY	VARCHAR2	(60)
VENDOR_POSTAL_CODE	VARCHAR2	(60)
VENDOR_COMPLETE_ADDRESS	VARCHAR2	(484)
VENDOR_TAX_REFERENCE	VARCHAR2	(50)
SALES_PERSON_NAME	VARCHAR2	(240)
TERM_NAME	VARCHAR2	(15)
TERM_DESC	VARCHAR2	(240)
VENDOR_TAX_REG_NUMBER	VARCHAR2	(50)
CUSTOMER_TAX_REG_NUMBER	VARCHAR2	(50)
CUSTOMER_TAX_AUTHORITY	VARCHAR2	(360)
USER_NAME	VARCHAR2	(4000)
LINE_TOTAL_AMOUNT	NUMBER
TAX_TOTAL_AMOUNT	NUMBER
TAX_RATE	NUMBER
VAT_TAX_TOTAL_AMOUNT	NUMBER
VAT_TAX_RATE	NUMBER
EXCISE_TAX_TOTAL_AMOUNT	NUMBER
EXCISE_TAX_RATE	NUMBER
EXEMPT_TAX_TOTAL_AMOUNT	NUMBER
EXEMPT_TAX_RATE	NUMBER
TRX_TOTAL_AMOUNT	NUMBER
TRX_TOTAL_IN_WORDS	VARCHAR2	(78)
PHONE_NUMBER	VARCHAR2	(62)
VENDOR_CONTACT_NAME	VARCHAR2	(423)
CUSTOMER_CONTACT_NAME	VARCHAR2	(102)
NULL_VALUE	VARCHAR2	(0)
CHIEF_ACCOUNTANT_NAME	VARCHAR2	(360)
GENERAL_DIRECTOR_NAME	VARCHAR2	(360)
VENDOR_TAX_KPP	VARCHAR2	(30)
VENDOR_TAX_PAYER_ID	VARCHAR2	(30)
LEGAL_ENTITY_ADDRESS	VARCHAR2	(905)

Query Text

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


SELECT ORIGINAL_COPY
,      CUST_ACCOUNT_ID
,      PARTY_ID
,      PARTY_SITE_ID
,      CUST_ACCT_SITE_ID
,      ACCOUNT_NUMBER
,      ACCOUNT_NAME
,      CUSTOMER_PARTY_NAME
,      CUSTOMER_TAX_REFERENCE
,      CUSTOMER_TAX_PAYER_ID
,      CUSTOMER_TAX_REF_NUMBER
,      REP_REG_NUMBER
,      RECEIPT_METHOD_NAME
,      PAYMENT_METHOD_NAME
,      CUSTOMER_ADDRESS
,      CUSTOMER_CITY
,      CUSTOMER_STATE
,      CUSTOMER_COUNTY
,      CUSTOMER_POSTAL_CODE
,      CUSTOMER_COMPLETE_ADDRESS
,      CUSTOMER_ATTR_COMPLETE_ADDRESS
,      CUSTOMER_NAME_ATTR
,      CUSTOMER_ADDRESS_ATTR
,      RCT_GLOBAL_ATTRIBUTE3
,      RCT_GLOBAL_ATTRIBUTE4
,      RCT_GLOBAL_ATTRIBUTE5
,      RCT_GLOBAL_ATTRIBUTE6
,      RCT_GLOBAL_ATTRIBUTE7
,      RCT_GLOBAL_ATTRIBUTE8
,      RCT_GLOBAL_ATTRIBUTE9
,      RCT_GLOBAL_ATTRIBUTE10
,      RCT_GLOBAL_ATTRIBUTE11
,      RCT_GLOBAL_ATTRIBUTE12
,      RCT_GLOBAL_ATTRIBUTE13
,      RCT_GLOBAL_ATTRIBUTE14
,      RCT_GLOBAL_ATTRIBUTE15
,      TRANSACTION_ID
,      TRANSACTION_NUMBER
,      TRANSACTION_DATE
,      TRANSACTION_TERM_DUE_DATE
,      TRANSACTION_CURRENCY_CODE
,      DOCUMENT_SEQUENCE_NUMBER
,      WAYBILL_NUMBER
,      TRANSACTION_TYPE
,      SHIPPING_BILL
,      SHIPPING_DATE
,      VENDOR_PARTY_NAME
,      VENDOR_ADDRESS
,      VENDOR_CITY
,      VENDOR_STATE
,      VENDOR_COUNTY
,      VENDOR_POSTAL_CODE
,      VENDOR_COMPLETE_ADDRESS
,      VENDOR_TAX_REFERENCE
,      SALES_PERSON_NAME
,      TERM_NAME
,      TERM_DESC
,      VENDOR_TAX_REG_NUMBER
,      CUSTOMER_TAX_REG_NUMBER
,      CUSTOMER_TAX_AUTHORITY
,      USER_NAME
,      LINE_TOTAL_AMOUNT
,      TAX_TOTAL_AMOUNT
,      TAX_RATE
,      VAT_TAX_TOTAL_AMOUNT
,      VAT_TAX_RATE
,      EXCISE_TAX_TOTAL_AMOUNT
,      EXCISE_TAX_RATE
,      EXEMPT_TAX_TOTAL_AMOUNT
,      EXEMPT_TAX_RATE
,      TRX_TOTAL_AMOUNT
,      TRX_TOTAL_IN_WORDS
,      PHONE_NUMBER
,      VENDOR_CONTACT_NAME
,      CUSTOMER_CONTACT_NAME
,      NULL_VALUE
,      CHIEF_ACCOUNTANT_NAME
,      GENERAL_DIRECTOR_NAME
,      VENDOR_TAX_KPP
,      VENDOR_TAX_PAYER_ID
,      LEGAL_ENTITY_ADDRESS
FROM APPS.ARBPA_CUSTOMER_TRX_HEADER;

Dependencies

[top of page]

APPS.ARBPA_CUSTOMER_TRX_HEADER references the following:

APPS: AR_RECEIPT_METHODS; FND_GLOBAL - show dependent code; FND_TERRITORIES_TL; HR_GENERAL - show dependent code; HR_LOCATIONS; HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_ORGANIZATION_PROFILES; HZ_PARTIES; HZ_PARTY_SITES; HZ_RELATIONSHIPS; IBY_FNDCPT_PMT_CHNNLS_VL; RA_CUSTOMER_TRX_ALL; RA_CUSTOMER_TRX_LINES_ALL; RA_CUST_TRX_TYPES_ALL; RA_SALESREPS_ALL; RA_TERMS; XLE_CONTACT_GRP - show dependent code; XLE_ENTITY_PROFILES; XLE_ETB_PROFILES; XLE_JURISDICTIONS_VL; XLE_LEGALAUTH_V; XLE_REGISTRATIONS; ZX_LINES; ZX_PARTY_TAX_PROFILE; ZX_REGISTRATIONS

APPS.ARBPA_CUSTOMER_TRX_HEADER is not referenced by any database object