[Home] [Help] [Dependency Information]

VIEW: APPS.RA_CUSTOMER_TRX_PARTIAL_V

Object Details

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      CUSTOMER_TRX_ID
,      TRX_NUMBER
,      OLD_TRX_NUMBER
,      CT_RELATED_TRX_NUMBER
,      CT_MODEL_TRX_NUMBER
,      TRX_DATE
,      TERM_DUE_DATE
,      PREVIOUS_CUSTOMER_TRX_ID
,      INITIAL_CUSTOMER_TRX_ID
,      RELATED_BATCH_SOURCE_ID
,      RELATED_CUSTOMER_TRX_ID
,      CUST_TRX_TYPE_ID
,      BATCH_ID
,      BATCH_SOURCE_ID
,      REASON_CODE
,      TERM_ID
,      PRIMARY_SALESREP_ID
,      AGREEMENT_ID
,      CREDIT_METHOD_FOR_RULES
,      CREDIT_METHOD_FOR_INSTALLMENTS
,      RECEIPT_METHOD_ID
,      INVOICING_RULE_ID
,      SHIP_VIA
,      FOB_POINT
,      FINANCE_CHARGES
,      COMPLETE_FLAG
,      CUSTOMER_BANK_ACCOUNT_ID
,      RECURRED_FROM_TRX_NUMBER
,      STATUS_TRX
,      DEFAULT_TAX_EXEMPT_FLAG
,      SOLD_TO_CUSTOMER_ID
,      SOLD_TO_SITE_USE_ID
,      SOLD_TO_CONTACT_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      RAA_BILL_TO_ADDRESS_ID
,      BILL_TO_CONTACT_ID
,      BILL_TO_TAXPAYER_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_SITE_USE_ID
,      RAA_SHIP_TO_ADDRESS_ID
,      SHIP_TO_CONTACT_ID
,      SHIP_TO_TAXPAYER_ID
,      REMIT_TO_ADDRESS_ID
,      INVOICE_CURRENCY_CODE
,      CREATED_FROM
,      SET_OF_BOOKS_ID
,      PRINTING_ORIGINAL_DATE
,      PRINTING_LAST_PRINTED
,      PRINTING_OPTION
,      PRINTING_COUNT
,      PRINTING_PENDING
,      LAST_PRINTED_SEQUENCE_NUM
,      PURCHASE_ORDER
,      PURCHASE_ORDER_REVISION
,      PURCHASE_ORDER_DATE
,      CUSTOMER_REFERENCE
,      CUSTOMER_REFERENCE_DATE
,      COMMENTS
,      INTERNAL_NOTES
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      TERRITORY_ID
,      END_DATE_COMMITMENT
,      START_DATE_COMMITMENT
,      ORIG_SYSTEM_BATCH_NAME
,      SHIP_DATE_ACTUAL
,      WAYBILL_NUMBER
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      PAYING_CUSTOMER_ID
,      PAYING_SITE_USE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INTERFACE_HEADER_CONTEXT
,      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
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      DEFAULT_USSGL_TRANSACTION_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      RAC_BILL_TO_CUSTOMER_NAME
,      RAC_BILL_TO_CUSTOMER_NUM
,      SU_BILL_TO_LOCATION
,      RAA_BILL_TO_ADDRESS1
,      RAA_BILL_TO_ADDRESS2
,      RAA_BILL_TO_ADDRESS3_DB
,      RAA_BILL_TO_ADDRESS3
,      RAA_BILL_TO_CITY
,      RAA_BILL_TO_COUNTY
,      RAA_BILL_TO_STATE
,      RAA_BILL_TO_PROVINCE
,      RAA_BILL_TO_POSTAL_CODE
,      FT_BILL_TO_COUNTRY
,      RAA_BILL_TO_CONCAT_ADDRESS
,      RACO_BILL_TO_CONTACT_NAME
,      RAC_SHIP_TO_CUSTOMER_NAME
,      RAC_SHIP_TO_CUSTOMER_NUM
,      SU_SHIP_TO_LOCATION
,      RAA_SHIP_TO_ADDRESS1
,      RAA_SHIP_TO_ADDRESS2
,      RAA_SHIP_TO_ADDRESS3_DB
,      RAA_SHIP_TO_ADDRESS3
,      RAA_SHIP_TO_CITY
,      RAA_SHIP_TO_COUNTY
,      RAA_SHIP_TO_STATE
,      RAA_SHIP_TO_PROVINCE
,      RAA_SHIP_TO_POSTAL_CODE
,      FT_SHIP_TO_COUNTRY
,      RAA_SHIP_TO_CONCAT_ADDRESS
,      RACO_SHIP_TO_CONTACT_NAME
,      RAC_SOLD_TO_CUSTOMER_NAME
,      RAC_SOLD_TO_CUSTOMER_NUM
,      RAC_PAYING_CUSTOMER_NAME
,      RAC_PAYING_CUSTOMER_NUM
,      SU_PAYING_CUSTOMER_LOCATION
,      RAA_REMIT_TO_ADDRESS1
,      RAA_REMIT_TO_ADDRESS2
,      RAA_REMIT_TO_ADDRESS3_DB
,      RAA_REMIT_TO_ADDRESS3
,      RAA_REMIT_TO_CITY
,      RAA_REMIT_TO_COUNTY
,      RAA_REMIT_TO_STATE
,      RAA_REMIT_TO_PROVINCE
,      RAA_REMIT_TO_POSTAL_CODE
,      FT_REMIT_TO_COUNTRY
,      RAA_CONCAT_REMIT_TO_ADDRESS
,      APBA_BANK_ACCOUNT_NAME
,      APBA_BANK_ACCOUNT_NUM
,      APBA_INACTIVE_DATE
,      APB_CUSTOMER_BANK_NAME
,      APB_CUSTOMER_BANK_BRANCH_NAME
,      ARM_RECEIPT_METHOD_NAME
,      ARM_PAYMENT_TYPE_CODE
,      ARC_CREATION_METHOD_CODE
,      BS_BATCH_SOURCE_NAME
,      BS_AUTO_TRX_NUMBERING_FLAG
,      BS_COPY_DOC_NUMBER_FLAG
,      RAB_BATCH_NAME
,      CTT_TYPE_NAME
,      CTT_CLASS
,      RAS_PRIMARY_SALESREP_NAME
,      RAS_PRIMARY_SALESREP_NUM
,      RAT_TERM_NAME
,      RAT_TERM_IN_USE_FLAG
,      SOA_AGREEMENT_NAME
,      OF_SHIP_VIA_NAME
,      OF_ORGANIZATION_ID
,      AL_FOB_MEANING
,      AL_DEFAULT_TAX_EXEMPT_FLAG
,      CT_REFERENCE
,      GD_GL_DATE
,      GDCT_USER_EXCHANGE_RATE_TYPE
,      CT_INVOICE_FOR_CB
,      PS_DISPUTE_AMOUNT
,      PS_DISPUTE_DATE
,      DH_MAX_DISPUTE_DATE
,      REV_RECOG_RUN_FLAG
,      POSTED_FLAG
,      SELECTED_FOR_PAYMENT_FLAG
,      ACTIVITY_FLAG
,      CTT_POST_TO_GL_FLAG
,      CTT_OPEN_RECEIVABLES_FLAG
,      CTT_ALLOW_FREIGHT_FLAG
,      CTT_CREATION_SIGN
,      CTT_ALLOW_OVERAPPLICATION_FLAG
,      CTT_NATURAL_APP_ONLY_FLAG
,      CTT_TAX_CALCULATION_FLAG
,      CTT_DEFAULT_STATUS
,      CTT_DEFAULT_TERM
,      CTT_DEFAULT_PRINTING_OPTION
,      RULES_FLAG
,      PRINTED_FLAG
,      CM_AGAINST_TRX_FLAG
,      SITE_STATUS
,      CUSTOMER_STATUS
,      OVERRIDE_TERMS
,      COMMITMENTS_EXIST_FLAG
,      AGREEMENTS_EXIST_FLAG
,      ATCHMT_FLAG
,      GLOBAL_ATTRIBUTE21
,      GLOBAL_ATTRIBUTE22
,      GLOBAL_ATTRIBUTE23
,      GLOBAL_ATTRIBUTE24
,      GLOBAL_ATTRIBUTE25
,      GLOBAL_ATTRIBUTE26
,      GLOBAL_ATTRIBUTE27
,      GLOBAL_ATTRIBUTE28
,      GLOBAL_ATTRIBUTE29
,      GLOBAL_ATTRIBUTE30
,      BS_BATCH_SOURCE_TYPE
,      ORG_ID
,      RA_BILLING_NUMBER
,      LEGAL_ENTITY_ID
,      PAYMENT_TRXN_EXTENSION_ID
,      ARM_PAYMENT_CHANNEL_CODE
,      BILLING_DATE
,      DEFAULT_REFERENCE
FROM APPS.RA_CUSTOMER_TRX_PARTIAL_V;

Dependencies

[top of page]

APPS

ARH_ADDR_PKG - show dependent code

ARPT_SQL_FUNC_UTIL - show dependent code

AR_LOOKUPS

AR_RECEIPT_CLASSES

AR_RECEIPT_METHODS

FND_ATTACHMENT_UTIL_PKG - show dependent code

FND_TERRITORIES_VL

GL_DAILY_CONVERSION_TYPES

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_ROLES

HZ_CUST_ACCT_SITES

HZ_CUST_SITE_USES_ALL

HZ_LOCATIONS

HZ_PARTIES

HZ_PARTY_SITES

HZ_RELATIONSHIPS

ORG_FREIGHT

RA_BATCHES_ALL

RA_BATCH_SOURCES_ALL

RA_CUSTOMER_TRX

RA_CUSTOMER_TRX_ALL

RA_CUST_TRX_LINE_GL_DIST_ALL

RA_CUST_TRX_TYPES_ALL

RA_TERMS

SO_AGREEMENTS

APPS

JL_JLZZRCVI_XMLP_PKG - show dependent code