[Home] [Help] [Dependency Information]
Object Name: | OKE_DTS_PAYABLES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
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) | Yes | 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 |
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;
APPS.OKE_DTS_PAYABLES_V is not referenced by any database object
|
|
|