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

Object Details

Object Name:	RA_INTERFACE_LINES_ALL_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
CLAIM_NUMBER	VARCHAR2	(150)
CLAIM_ID	VARCHAR2	(150)
CLAIM_LINE_ID	VARCHAR2	(150)
EARNINGS_ATTACHED_FLAG	VARCHAR2	(150)
CUSTOMER_REFERENCE	VARCHAR2	(150)
CUSTOMER_REASON	VARCHAR2	(150)
CLAIM_REASON	VARCHAR2	(150)
CONTRACT_ID	NUMBER
SERVICE_ID	NUMBER
CONTRACT_NUMBER	NUMBER
BILLING_ID	NUMBER
CONTRACT_TYPE_ID	NUMBER
CONTRACT_GROUP_ID	NUMBER
TRANSACTION_START_DATE	DATE
TRANSACTION_END_DATE	DATE
TRANSACTION_AMOUNT	NUMBER
SERVICE_TRANSACTION_ID	VARCHAR2	(150)
NEGOTIATION_NUMBER	VARCHAR2	(150)
VENDOR_PARTY_ID	VARCHAR2	(150)
VENDOR_PARTY_SITE_ID	VARCHAR2	(150)
CONTACT_PARTY_ID	VARCHAR2	(150)
BILL_NO	VARCHAR2	(150)
BILL_INFO	VARCHAR2	(150)
EMD_GROUP_ID	VARCHAR2	(150)
EMD_TRANSACTION_ID	VARCHAR2	(150)
BILLING_PARTY_ID	VARCHAR2	(150)
BILLING_SITE_USE_ID	VARCHAR2	(150)
BILLING_INTERFACE_REQUEST_ID	VARCHAR2	(150)
BILLING_PERIOD	VARCHAR2	(150)
BILLING_ACTIVITY_TYPE_ID	VARCHAR2	(150)
BILL_TO_PARTY_ID	VARCHAR2	(150)
ACTIVITY_ID	VARCHAR2	(150)
ACTIVITY_DATE	VARCHAR2	(150)
PO_NUMBER	VARCHAR2	(150)
PO_LINE_NUMBER	NUMBER
RECEIVING_INVENTORY_ORG	VARCHAR2	(150)
PURCHASING_OPERATING_UNIT	VARCHAR2	(150)
RECEIVING_OPERATING_UNIT	VARCHAR2	(150)
PO_LINE_LOCATION_ID	NUMBER
REFERENCE	VARCHAR2	(150)
CREATE_AP_INVOICE	VARCHAR2	(150)
PO_SHIPMENT_NUMBER	NUMBER
INVOICE_TYPE	VARCHAR2	(150)
INVOICE_LINE_IDENTIFIER	VARCHAR2	(150)
ORDER_NUMBER	VARCHAR2	(150)
ORDER_LINE_NUMBER	VARCHAR2	(150)
SHIPPING_WAREHOUSE	VARCHAR2	(150)
SELLING_OPERATING_UNIT	VARCHAR2	(150)
SHIPPING_OPERATING_UNIT	VARCHAR2	(150)
ORDER_LINE_ID	NUMBER
ORDER_ORG_ID	VARCHAR2	(150)
PRICE_ADJUSTMENT_ID_ORDER_ID	NUMBER
BATCH_ID	VARCHAR2	(150)
TRX_ID	VARCHAR2	(150)
LINE_ID	VARCHAR2	(150)
LOAN_ID	NUMBER
AMORTIZATION_SCHEDULE_ID	NUMBER
PAYMENT_NUMBER	NUMBER
LOAN_NUMBER	VARCHAR2	(150)
LINE_TYPE	VARCHAR2	(150)
PAYMENT_ORDER	NUMBER
PARENT_AMORTIZATION_ID	NUMBER
TRANSACTION_ID	VARCHAR2	(150)
CONTRACT_NUMBER1	VARCHAR2	(150)
CONTRACT_MODIFIER	VARCHAR2	(150)
INSTANCE_NO	VARCHAR2	(150)
BILLED_FROM	VARCHAR2	(150)
BILLED_TO	VARCHAR2	(150)
AMOUNT	VARCHAR2	(150)
BILLED_FROM_DATE	VARCHAR2	(150)
START_DATE	VARCHAR2	(150)
BILL_INSTALLMENT_NUMBER	VARCHAR2	(150)
ORDER_TYPE	VARCHAR2	(150)
DELIVERY	VARCHAR2	(150)
WAYBILL	VARCHAR2	(150)
COUNT	VARCHAR2	(150)
PICKING_LINE_ID	VARCHAR2	(150)
BILL_OF_LADING	VARCHAR2	(150)
CUSTOMER_ITEM_PART	VARCHAR2	(150)
WAREHOUSE	VARCHAR2	(150)
PRICE_ADJUSTMENT_ID	VARCHAR2	(150)
SHIPMENT_NUMBER	VARCHAR2	(150)
OPTION_NUMBER	VARCHAR2	(150)
SERVICE_NUMBER	VARCHAR2	(150)
PROVIDER_PROJECT_NUMBER	VARCHAR2	(150)
DRAFT_INVOICE_NUMBER	VARCHAR2	(150)
PROJECT_MANAGER	VARCHAR2	(150)
CROSS_CHARGED_PROJECT_NUMBER	VARCHAR2	(150)
LINE_NUMBER	VARCHAR2	(150)
TYPE	VARCHAR2	(150)
PROJECT_NUMBER	VARCHAR2	(150)
AGREEMENT_NUMBER	VARCHAR2	(150)
PROJECT_ORGANIZATION	VARCHAR2	(150)
LEASE	VARCHAR2	(150)
LOCATION	VARCHAR2	(150)
PROJECT_NAME	VARCHAR2	(150)
TASK	VARCHAR2	(150)
EXPENDITURE_ITEM_DATE	VARCHAR2	(150)
ORGANIZATION	VARCHAR2	(150)
EXPENDITURE_TYPE	VARCHAR2	(150)
PAYMENT_ITEM_PURPOSE	VARCHAR2	(150)
PAYMENT_ITEM_TYPE	VARCHAR2	(150)
LEASE_NUMBER	VARCHAR2	(150)
SERVICE_ORDER_NUMBER	VARCHAR2	(150)
REFERENCE_NUMBER	NUMBER
TERMINATION_START_DATE	VARCHAR2	(150)
TERMINATION_END_DATE	VARCHAR2	(150)
SERVICE_ORDER_LINE_ID	VARCHAR2	(150)
CUSTOMER_REF	VARCHAR2	(150)
CUSTOMER_SITE	VARCHAR2	(150)
BATCH_SOURCE	VARCHAR2	(150)
PACKAGE_ID	VARCHAR2	(150)
TRX_NUMBER	VARCHAR2	(150)
TRX_TYPE	VARCHAR2	(150)
ORIG_TRX_REF	VARCHAR2	(150)
WORK_ORDER	VARCHAR2	(150)
WORK_ORDER_ID	VARCHAR2	(150)
INVOICE_NUMBER	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(2144)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      CLAIM_NUMBER
,      CLAIM_ID
,      CLAIM_LINE_ID
,      EARNINGS_ATTACHED_FLAG
,      CUSTOMER_REFERENCE
,      CUSTOMER_REASON
,      CLAIM_REASON
,      CONTRACT_ID
,      SERVICE_ID
,      CONTRACT_NUMBER
,      BILLING_ID
,      CONTRACT_TYPE_ID
,      CONTRACT_GROUP_ID
,      TRANSACTION_START_DATE
,      TRANSACTION_END_DATE
,      TRANSACTION_AMOUNT
,      SERVICE_TRANSACTION_ID
,      NEGOTIATION_NUMBER
,      VENDOR_PARTY_ID
,      VENDOR_PARTY_SITE_ID
,      CONTACT_PARTY_ID
,      BILL_NO
,      BILL_INFO
,      EMD_GROUP_ID
,      EMD_TRANSACTION_ID
,      BILLING_PARTY_ID
,      BILLING_SITE_USE_ID
,      BILLING_INTERFACE_REQUEST_ID
,      BILLING_PERIOD
,      BILLING_ACTIVITY_TYPE_ID
,      BILL_TO_PARTY_ID
,      ACTIVITY_ID
,      ACTIVITY_DATE
,      PO_NUMBER
,      PO_LINE_NUMBER
,      RECEIVING_INVENTORY_ORG
,      PURCHASING_OPERATING_UNIT
,      RECEIVING_OPERATING_UNIT
,      PO_LINE_LOCATION_ID
,      REFERENCE
,      CREATE_AP_INVOICE
,      PO_SHIPMENT_NUMBER
,      INVOICE_TYPE
,      INVOICE_LINE_IDENTIFIER
,      ORDER_NUMBER
,      ORDER_LINE_NUMBER
,      SHIPPING_WAREHOUSE
,      SELLING_OPERATING_UNIT
,      SHIPPING_OPERATING_UNIT
,      ORDER_LINE_ID
,      ORDER_ORG_ID
,      PRICE_ADJUSTMENT_ID_ORDER_ID
,      BATCH_ID
,      TRX_ID
,      LINE_ID
,      LOAN_ID
,      AMORTIZATION_SCHEDULE_ID
,      PAYMENT_NUMBER
,      LOAN_NUMBER
,      LINE_TYPE
,      PAYMENT_ORDER
,      PARENT_AMORTIZATION_ID
,      TRANSACTION_ID
,      CONTRACT_NUMBER1
,      CONTRACT_MODIFIER
,      INSTANCE_NO
,      BILLED_FROM
,      BILLED_TO
,      AMOUNT
,      BILLED_FROM_DATE
,      START_DATE
,      BILL_INSTALLMENT_NUMBER
,      ORDER_TYPE
,      DELIVERY
,      WAYBILL
,      COUNT
,      PICKING_LINE_ID
,      BILL_OF_LADING
,      CUSTOMER_ITEM_PART
,      WAREHOUSE
,      PRICE_ADJUSTMENT_ID
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      SERVICE_NUMBER
,      PROVIDER_PROJECT_NUMBER
,      DRAFT_INVOICE_NUMBER
,      PROJECT_MANAGER
,      CROSS_CHARGED_PROJECT_NUMBER
,      LINE_NUMBER
,      TYPE
,      PROJECT_NUMBER
,      AGREEMENT_NUMBER
,      PROJECT_ORGANIZATION
,      LEASE
,      LOCATION
,      PROJECT_NAME
,      TASK
,      EXPENDITURE_ITEM_DATE
,      ORGANIZATION
,      EXPENDITURE_TYPE
,      PAYMENT_ITEM_PURPOSE
,      PAYMENT_ITEM_TYPE
,      LEASE_NUMBER
,      SERVICE_ORDER_NUMBER
,      REFERENCE_NUMBER
,      TERMINATION_START_DATE
,      TERMINATION_END_DATE
,      SERVICE_ORDER_LINE_ID
,      CUSTOMER_REF
,      CUSTOMER_SITE
,      BATCH_SOURCE
,      PACKAGE_ID
,      TRX_NUMBER
,      TRX_TYPE
,      ORIG_TRX_REF
,      WORK_ORDER
,      WORK_ORDER_ID
,      INVOICE_NUMBER
,      CONCATENATED_SEGMENTS
FROM APPS.RA_INTERFACE_LINES_ALL_DFV;

Dependencies

[top of page]

APPS.RA_INTERFACE_LINES_ALL_DFV references the following:

APPS: FND_NUMBER - show dependent code; RA_INTERFACE_LINES_ALL

APPS.RA_INTERFACE_LINES_ALL_DFV is not referenced by any database object