[Home] [Help] [Dependency Information]

VIEW: APPS.AR_CUSTOMER_BILLS_TRX_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      BATCH_SOURCE_NAME
,      BATCH_SOURCE_ID
,      AUTO_TRX_NUMBERING_FLAG
,      TRANS_TYPE
,      CUST_TRX_TYPE_ID
,      SIGNED_FLAG
,      DRAWEE_ISSUED_FLAG
,      MAGNETIC_FORMAT_CODE
,      POST_TO_GL
,      DEFAILT_PRINTING_OPTION
,      FORMAT_PROGRAM_ID
,      CUSTOMER_TRX_ID
,      PRINTING_LAST_PRINTED
,      CUSTOMER_REFERENCE
,      DOC_SEQUENCE_VALUE
,      DOC_SEQUENCE_ID
,      COMMENTS
,      INVOICE_CURRENCY_CODE
,      TRX_DATE
,      BR_AMOUNT
,      BR_UNPAID_FLAG
,      BR_ON_HOLD_FLAG
,      TERM_DUE_DATE
,      TRX_NUMBER
,      OLD_TRX_NUMBER
,      SPECIAL_INSTRUCTIONS
,      PRINTING_OPTION
,      COMPLETE_FLAG
,      OVERRIDE_REMIT_ACCOUNT_FLAG
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_FROM
,      TRANSACTION_BATCH_ID
,      CONTACT_NAME
,      DRAWEE_CONTACT_ID
,      DRAWEE_ID
,      DRAWEE_NAME
,      DRAWEE_NUMBER
,      JGZZ_FISCAL_CODE
,      TAX_REFERENCE
,      DRAWEE_CLASS
,      DRAWEE_CATEGORY_CODE
,      DRAWEE_CATEGORY
,      LOCATION
,      DRAWEE_SITE_USE_ID
,      ADDRESS_ID
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      DB_ADDRESS3
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE_STATE
,      TERRITORY_SHORT_CODE
,      SITE_PRIMARY_FLAG
,      DRAWEE_BANK_NAME
,      DRAWEE_BANK_NUM
,      DRAWEE_BANK_NUMBER
,      DRAWEE_BRANCH_NAME
,      DRAWEE_ACCOUNT_NUM
,      DRAWEE_ACCOUNT_NAME
,      DRAWEE_ACCOUNT_CURRENCY_CODE
,      DRAWEE_BANK_ADDRESS1
,      DRAWEE_BANK_ADDRESS2
,      DRAWEE_BANK_ADDRESS3
,      DRAWEE_DB_BANK_ADDRESS3
,      DRAWEE_BANK_CITY
,      DRAWEE_BANK_AREA_CODE
,      DRAWEE_BANK_PROVINCE
,      DRAWEE_BANK_STATE
,      DRAWEE_BANK_PROVINCE_STATE
,      DRAWEE_BANK_COUNTRY
,      DRAWEE_BANK_ACCOUNT_ID
,      REMIT_BANK_NAME
,      REMIT_BANK_NUM
,      REMIT_BANK_NUMBER
,      REMIT_BRANCH_NAME
,      REMIT_ACCOUNT_NUM
,      REMIT_ACCOUNT_NAME
,      REMIT_ACCOUNT_CURRENCY_CODE
,      REMIT_BANK_ADDRESS1
,      REMIT_BANK_ADDRESS2
,      REMIT_BANK_ADDRESS3
,      REMIT_DB_BANK_ADDRESS3
,      REMIT_BANK_CITY
,      REMIT_BANK_ZIP_CODE
,      REMIT_BANK_PROVINCE
,      REMIT_BANK_STATE
,      REMIT_BANK_PROVINCE_STATE
,      REMIT_BANK_COUNTRY
,      REMIT_BANK_ACCOUNT_ID
,      REMIT_BANK_ACCT_USE_ID
,      STATUS
,      STATUS_MEANING
,      GL_DATE
,      POSTING_CONTROL_ID
,      REMITTANCE_BATCH_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      LEGAL_ENTITY_ID
,      PAYMENT_TRXN_EXTENSION_ID
FROM APPS.AR_CUSTOMER_BILLS_TRX_V;

Dependencies

[top of page]

APPS

ARH_ADDR_PKG - show dependent code

ARPT_SQL_FUNC_UTIL - show dependent code

AR_LOOKUPS

AR_TRANSACTION_HISTORY

CE_BANK_ACCOUNTS

CE_BANK_ACCT_USES_OU_V

FND_GLOBAL - show dependent code

FND_TERRITORIES_VL

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_ROLES

HZ_CUST_ACCT_SITES

HZ_CUST_SITE_USES

HZ_LOCATIONS

HZ_ORGANIZATION_PROFILES

HZ_PARTIES

HZ_PARTY_SITES

HZ_RELATIONSHIPS

IBY_EXT_BANK_ACCOUNTS

IBY_FNDCPT_TRXN_PUB - show dependent code

IBY_TRXN_EXTENSIONS_V

RA_BATCH_SOURCES_ALL

RA_CUSTOMER_TRX

RA_CUST_TRX_TYPES_ALL

APPS.AR_CUSTOMER_BILLS_TRX_V is not referenced by any database object