[Home] [Help] [Dependency Information]
Object Name: | PA_DEDUCTIONS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEDUCTION_REQ_ID | NUMBER | (15) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
VENDOR_ID | NUMBER | (15) | Yes | |
VENDOR_SITE_ID | NUMBER | Yes | ||
CHANGE_DOC_NUM | VARCHAR2 | (30) | ||
CHANGE_DOC_TYPE | VARCHAR2 | (15) | ||
CI_ID | NUMBER | |||
PO_HEADER_ID | NUMBER | |||
PO_NUMBER | VARCHAR2 | (20) | ||
DEDUCTION_REQ_NUM | VARCHAR2 | (30) | Yes | |
DEBIT_MEMO_NUM | VARCHAR2 | (30) | ||
CURRENCY_CODE | VARCHAR2 | (30) | Yes | |
CONVERSION_RATETYPE | VARCHAR2 | (30) | ||
CONVERSION_RATEDATE | DATE | |||
CONVERSION_RATE | NUMBER | |||
TOTAL_AMOUNT | NUMBER | |||
TOTAL_PFC_AMOUNT | NUMBER | |||
DEDUCTION_REQ_DATE | DATE | Yes | ||
DEBIT_MEMO_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (4000) | ||
STATUS | VARCHAR2 | (15) | ||
ORG_ID | NUMBER | Yes | ||
DOCUMENT_TYPE | VARCHAR2 | (1) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT DEDUCTION_REQ_ID
, PROJECT_ID
, VENDOR_ID
, VENDOR_SITE_ID
, CHANGE_DOC_NUM
, CHANGE_DOC_TYPE
, CI_ID
, PO_HEADER_ID
, PO_NUMBER
, DEDUCTION_REQ_NUM
, DEBIT_MEMO_NUM
, CURRENCY_CODE
, CONVERSION_RATETYPE
, CONVERSION_RATEDATE
, CONVERSION_RATE
, TOTAL_AMOUNT
, TOTAL_PFC_AMOUNT
, DEDUCTION_REQ_DATE
, DEBIT_MEMO_DATE
, DESCRIPTION
, STATUS
, ORG_ID
, DOCUMENT_TYPE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATION_DATE
, LAST_UPDATED_BY
FROM PA.PA_DEDUCTIONS_ALL#;
|
|
|