DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.RA_CUSTOMER_TRX_ALL2_DFV

Object Details
Object Name: RA_CUSTOMER_TRX_ALL2_DFV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTEXT_VALUE VARCHAR2 (30)
CLAIM_NUMBER VARCHAR2 (150)
CUSTOMER_REFERENCE VARCHAR2 (150)
CUSTOMER_REASON VARCHAR2 (150)
CLAIM_REASON VARCHAR2 (150)
BILLING_PARTY_ID VARCHAR2 (150)
BILLING_SITE_USE_ID VARCHAR2 (150)
BILLING_INTERFACE_REQUEST_ID VARCHAR2 (150)
BILLING_PERIOD VARCHAR2 (150)
BILL_TO_PARTY_ID VARCHAR2 (150)
PRIVATE_LABEL VARCHAR2 (150)
INVOICE_GROUP VARCHAR2 (150)
INVOICE_TYPE VARCHAR2 (150)
TERMINATION_QUOTE_NUMBER VARCHAR2 (150)
OKL_SOURCE_BILLING_TRANSACTION VARCHAR2 (150)
PROJECT_NUMBER VARCHAR2 (150)
DRAFT_INVOICE_NUMBER VARCHAR2 (150)
AGREEMENT_NUMBER VARCHAR2 (150)
PROJECT_ORGANIZATION VARCHAR2 (150)
PROJECT_MANAGER VARCHAR2 (150)
CONCATENATED_SEGMENTS VARCHAR2 (785)
Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      CLAIM_NUMBER
,      CUSTOMER_REFERENCE
,      CUSTOMER_REASON
,      CLAIM_REASON
,      BILLING_PARTY_ID
,      BILLING_SITE_USE_ID
,      BILLING_INTERFACE_REQUEST_ID
,      BILLING_PERIOD
,      BILL_TO_PARTY_ID
,      PRIVATE_LABEL
,      INVOICE_GROUP
,      INVOICE_TYPE
,      TERMINATION_QUOTE_NUMBER
,      OKL_SOURCE_BILLING_TRANSACTION
,      PROJECT_NUMBER
,      DRAFT_INVOICE_NUMBER
,      AGREEMENT_NUMBER
,      PROJECT_ORGANIZATION
,      PROJECT_MANAGER
,      CONCATENATED_SEGMENTS
FROM APPS.RA_CUSTOMER_TRX_ALL2_DFV;

Dependencies

[top of page]

APPS.RA_CUSTOMER_TRX_ALL2_DFV references the following:

SchemaAPPS
SynonymRA_CUSTOMER_TRX_ALL

APPS.RA_CUSTOMER_TRX_ALL2_DFV is not referenced by any database object