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

VIEW: PA.PA_DEDUCTIONS_ALL#

Object Details
Object Name: PA_DEDUCTIONS_ALL#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

PA.PA_DEDUCTIONS_ALL# references the following:

SchemaPA
TablePA_DEDUCTIONS_ALL
PA.PA_DEDUCTIONS_ALL# is referenced by following:

SchemaAPPS
SynonymPA_DEDUCTIONS_ALL