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

Object Details

Object Name:	OKE_DTS_PAYABLES_V
Object Type:	VIEW
Owner:	APPS
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

Name	Datatype	Length	Mandatory	Comments
K_HEADER_ID	NUMBER			Contract header unique identifier
K_LINE_ID	NUMBER			Contract line unique identifier
DELIVERABLE_ID	NUMBER			Contract deliverable unique identifier
PROJECT_ID	NUMBER			Project unique identifier
TASK_ID	NUMBER			Task unique identifier
INVOICE_ID	NUMBER	(15)	Yes	Invoice unique identifier
INVOICE_NUM	VARCHAR2	(50)	Yes	Invoice number
INVOICE_DATE	DATE			Invoice date
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes	Invoice currency
INVOICE_TYPE	VARCHAR2	(80)	Yes	Invoice type
INVOICE_AMOUNT	NUMBER			Invoice amount
PAYMENT_TERM	VARCHAR2	(50)	Yes	Payment term
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)	Yes	Payment currency
PAID_AMOUNT	NUMBER			Paid amount
UNPAID_AMOUNT	NUMBER			Unpaid amount
SUPPLIER_ID	NUMBER	(15)		Supplier unique identifier
SUPPLIER_NAME	VARCHAR2	(240)		Supplier name
SUPPLIER_NUMBER	VARCHAR2	(30)	Yes	Supplier number
SUPPLIER_SITE_ID	NUMBER	(15)		Supplier site unique identifier
SUPPLIER_SITE	VARCHAR2	(15)		Supplier site
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes	Invoice distribution unique identifier
INVOICE_DISTRIBUTION_NUM	NUMBER	(15)	Yes	Invoice distribution number
LINE_TYPE	VARCHAR2	(80)		Invoice line type
AMOUNT	NUMBER			Amount
ALLOCATED_AMOUNT	NUMBER			Allocated amount
PO_NUMBER	VARCHAR2	(20)	Yes	PO number
PO_LINE_NUMBER	NUMBER		Yes	PO line number
PO_SHIPMENT_NUMBER	NUMBER			PO shipment number

Query Text

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


SELECT K_HEADER_ID
,      K_LINE_ID
,      DELIVERABLE_ID
,      PROJECT_ID
,      TASK_ID
,      INVOICE_ID
,      INVOICE_NUM
,      INVOICE_DATE
,      INVOICE_CURRENCY_CODE
,      INVOICE_TYPE
,      INVOICE_AMOUNT
,      PAYMENT_TERM
,      PAYMENT_CURRENCY_CODE
,      PAID_AMOUNT
,      UNPAID_AMOUNT
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_NUMBER
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_DISTRIBUTION_NUM
,      LINE_TYPE
,      AMOUNT
,      ALLOCATED_AMOUNT
,      PO_NUMBER
,      PO_LINE_NUMBER
,      PO_SHIPMENT_NUMBER
FROM APPS.OKE_DTS_PAYABLES_V;

Dependencies

[top of page]

APPS.OKE_DTS_PAYABLES_V references the following:

APPS: AP_CHRG_ALLOCATIONS_ALL; AP_INVOICES_ALL; AP_INVOICE_DISTRIBUTIONS_ALL; AP_LOOKUP_CODES; AP_PAYMENT_SCHEDULES_ALL; AP_TERMS; FND_GLOBAL - show dependent code; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.OKE_DTS_PAYABLES_V is not referenced by any database object