[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

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
,      CUST_TAX_REGN_NO
,      RECEIPT_METHOD_NAME
,      PAYMENT_METHOD_NAME
,      CUSTOMER_ADDRESS1
,      CUSTOMER_ADDRESS2
,      CUSTOMER_ADDRESS3
,      CUSTOMER_ADDRESS4
,      CUSTOMER_CITY
,      CUSTOMER_STATE
,      CUSTOMER_COUNTY
,      CUSTOMER_POSTAL_CODE
,      CUSTOMER_ATTR_COMPLETE_ADDRESS
,      TRX_GLOBAL_ATTRIBUTE1
,      TRX_GLOBAL_ATTRIBUTE2
,      TRX_GLOBAL_ATTRIBUTE3
,      TRX_GLOBAL_ATTRIBUTE4
,      TRX_GLOBAL_ATTRIBUTE5
,      TRX_GLOBAL_ATTRIBUTE6
,      TRX_GLOBAL_ATTRIBUTE7
,      TRX_GLOBAL_ATTRIBUTE8
,      TRX_GLOBAL_ATTRIBUTE9
,      TRX_GLOBAL_ATTRIBUTE10
,      TRX_GLOBAL_ATTRIBUTE11
,      TRX_GLOBAL_ATTRIBUTE12
,      TRX_GLOBAL_ATTRIBUTE13
,      TRX_GLOBAL_ATTRIBUTE14
,      TRX_GLOBAL_ATTRIBUTE15
,      TRX_GLOBAL_ATTRIBUTE16
,      TRX_GLOBAL_ATTRIBUTE17
,      TRX_GLOBAL_ATTRIBUTE18
,      TRX_GLOBAL_ATTRIBUTE19
,      TRX_GLOBAL_ATTRIBUTE20
,      TRX_GLOBAL_ATTRIBUTE_CATEGORY
,      TRANSACTION_ID
,      TRANSACTION_NUMBER
,      TRANSACTION_DATE
,      TRANSACTION_TERM_DUE_DATE
,      TRANSACTION_CURRENCY_CODE
,      DOCUMENT_SEQUENCE_NUMBER
,      TRANSACTION_TYPE
,      SHIPPING_BILL
,      SHIPPING_DATE
,      VENDOR_PARTY_NAME
,      VENDOR_ADDRESS1
,      VENDOR_ADDRESS2
,      VENDOR_ADDRESS3
,      VENDOR_ADDRESS4
,      VENDOR_CITY
,      VENDOR_STATE
,      VENDOR_COUNTY
,      VENDOR_POSTAL_CODE
,      VENDOR_TAX_REFERENCE
,      SALES_PERSON_NAME
,      TERM_DESC
,      VENDOR_TAX_REG_NUMBER
,      CUSTOMER_TAX_REG_NUMBER
,      CUSTOMER_TAX_AUTHORITY
,      USER_NAME
,      TERM_SEQUENCE_NUMBER
,      TRX_NUMBER
,      TRX_DATE
,      INVOICE_CURRENCY_CODE
,      TERM_NAME
,      WAYBILL_NUMBER
,      SHIP_VIA
,      SHIP_DATE_ACTUAL
,      PURCHASE_ORDER_NUMBER
,      PURCHASE_ORDER_DATE
,      TERM_DUE_DATE_FROM_PS
,      BILL_TO_CUSTOMER_NUMBER
,      BILL_TO_CUSTOMER_NAME
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_CITY
,      BILL_TO_STATE
,      BILL_TO_PROVINCE
,      BILL_TO_POSTAL_CODE
,      BILL_TO_COUNTRY
,      SHIP_TO_CUSTOMER_NAME
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_ADDRESS4
,      SHIP_TO_CITY
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_COUNTRY
,      SHIP_TO_STATE
,      SHIP_TO_PROVINCE
,      REMIT_TO_ADDRESS1
,      REMIT_TO_ADDRESS2
,      REMIT_TO_ADDRESS3
,      REMIT_TO_ADDRESS4
,      REMIT_TO_CITY
,      REMIT_TO_STATE
,      REMIT_TO_POSTAL_CODE
,      REMIT_TO_COUNTRY
,      BILL_TO_LOCATION
,      PRIMARY_SALESREP_NAME
,      LINE_AMOUNT
,      TAX_AMOUNT
,      FREIGHT_AMOUNT
,      TOTAL_AMOUNT
,      FINANCE_CHARGES
,      CUSTOMER_CONTACT_NAME
,      CUSTOMER_PHONE
,      CUSTOMER_FAX
,      SALES_ORDER
,      TRX_HAS_GROUPS
,      BILLING_LINE_LEVEL
,      FORMATTED_BILL_TO_ADDRESS
,      FORMATTED_SHIP_TO_ADDRESS
,      FORMATTED_REMIT_TO_ADDRESS
,      CURRENT_DATE
,      CONTRACT_NUMBER
,      PROFILE_CLASS_NAME
,      INTERFACE_HEADER_CONTEXT
,      TAX_PRINTING_OPTION
,      INTERFACE_HEADER_ATTRIBUTE1
,      INTERFACE_HEADER_ATTRIBUTE2
,      INTERFACE_HEADER_ATTRIBUTE3
,      INTERFACE_HEADER_ATTRIBUTE4
,      INTERFACE_HEADER_ATTRIBUTE5
,      INTERFACE_HEADER_ATTRIBUTE6
,      INTERFACE_HEADER_ATTRIBUTE7
,      INTERFACE_HEADER_ATTRIBUTE8
,      INTERFACE_HEADER_ATTRIBUTE9
,      INTERFACE_HEADER_ATTRIBUTE10
,      INTERFACE_HEADER_ATTRIBUTE11
,      INTERFACE_HEADER_ATTRIBUTE12
,      INTERFACE_HEADER_ATTRIBUTE13
,      INTERFACE_HEADER_ATTRIBUTE14
,      INTERFACE_HEADER_ATTRIBUTE15
,      SHIP_TO_LOCATION
,      NUMBER_OF_TERMS
,      TERMS_SEQUENCE_NUMBER
,      ORG_ID
,      CREATION_DATE
,      INTERNAL_NOTES
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_APPLIED
,      OUTSTANDING_BALANCE
,      AMOUNT_DUE_REMAINING
,      PAYMENTS_AND_CREDITS
,      AMOUNT_CHARGES
,      AMOUNT_ADJUSTED
,      TRX_TYPE
,      TERM_ID
,      PAYMENT_SCHEDULE_ID
,      COMMENTS
,      START_DATE_COMMITMENT
,      END_DATE_COMMITMENT
,      CREDIT_MEMO_REASON
,      PREVIOUS_CUSTOMER_TRX_ID
,      PREVIOUS_TRX_NUMBER
,      ORG_NAME
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      CT_REFERENCE
,      CUST_TRX_TYPE_ID
,      CUST_TRX_TYPE_NAME
,      BATCH_SOURCE_ID
,      BATCH_SOURCE_NAME
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SET_OF_BOOKS_ID
,      REASON_CODE
,      PURCHASE_ORDER_REVISION
,      CUSTOMER_REFERENCE
,      CUSTOMER_REFERENCE_DATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      ATTRIBUTE_CATEGORY
,      ORIG_SYSTEM_BATCH_NAME
,      FINANCE_CHARGE_INDICATOR
,      CREDIT_METHOD_FOR_RULES
,      CREDIT_METHOD_FOR_INSTALLMENTS
,      FOB_POINT
,      DEFAULT_USSGL_TRX_CODE_CONTEXT
,      DEFAULT_USSGL_TRANSACTION_CODE
,      RECURRED_FROM_TRX_NUMBER
,      STATUS_TRX
,      DOC_SEQUENCE_VALUE
,      EDI_PROCESSED_FLAG
,      EDI_PROCESSED_STATUS
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_EXCHANGE_DATE
,      MRC_EXCHANGE_RATE
,      PAYMENT_SERVER_ORDER_NUM
,      APPROVAL_CODE
,      ADDRESS_VERIFICATION_CODE
,      NUMBER_OF_DUE_DATES
,      STATUS
,      GL_DATE_CLOSED
,      ACTUAL_DATE_CLOSED
,      AMOUNT_LINE_ITEMS_REMAINING
,      AMOUNT_IN_DISPUTE
,      AMOUNT_CREDITED
,      RECEIVABLES_CHARGES_REMAINING
,      FREIGHT_REMAINING
,      TAX_REMAINING
,      DISCOUNT_TAKEN_EARNED
,      DISCOUNT_TAKEN_UNEARNED
,      ACCTD_AMOUNT_DUE_REMAINING
,      SPECIAL_INSTRUCTIONS
,      BILL_TO_COUNTY
,      SHIP_TO_COUNTY
,      REMIT_TO_COUNTY
,      BILL_TO_COUNTRY_NAME
,      SHIP_TO_COUNTRY_NAME
,      REVERSE_CHARGE_VAT_INVOICE
,      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
,      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

AP_AMOUNT_UTILITIES_PKG - show dependent code

AR_BPA_UTILS_PKG - show dependent code

AR_INVOICE_COUNT_TERMS_V

AR_LOOKUPS

AR_PAYMENT_SCHEDULES_ALL

AR_RECEIPT_METHODS

FND_ACCESS_CONTROL_UTIL - show dependent code

FND_CURRENCY - show dependent code

FND_GLOBAL - show dependent code

FND_MESSAGE - show dependent code

FND_TERRITORIES_TL

FND_TERRITORIES_VL

HR_GENERAL - show dependent code

HR_LOCATIONS

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNTS_ALL

HZ_CUST_ACCOUNT_ROLES

HZ_CUST_ACCT_SITES_ALL

HZ_CUST_SITE_USES_ALL

HZ_FORMAT_PUB - show dependent code

HZ_LOCATIONS

HZ_ORGANIZATION_PROFILES

HZ_PARTIES

HZ_PARTY_SITES

HZ_RELATIONSHIPS

IBY_FNDCPT_PMT_CHNNLS_VL

RA_BATCH_SOURCES_ALL

RA_CUSTOMER_TRX

RA_CUSTOMER_TRX_ALL

RA_CUSTOMER_TRX_LINES_ALL

RA_CUST_TRX_TYPES_ALL

RA_SALESREPS_ALL

RA_TERMS

RA_TERMS_LINES

XLE_CONTACT_GRP - show dependent code

XLE_ENTITY_PROFILES

XLE_ETB_PROFILES

XLE_FIRSTPARTY_INFORMATION_V

XLE_JURISDICTIONS_VL

XLE_LEGALAUTH_V

XLE_REGISTRATIONS

ZX_LINES

ZX_PARTY_TAX_PROFILE

ZX_RATES_B

ZX_REGISTRATIONS

ZX_REPORTING_TYPES_B

ZX_REPORT_CODES_ASSOC

APPS.ARBPA_CUSTOMER_TRX_HEADER is not referenced by any database object