Skip to content

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

VIEW: PA.PA_DEDUCTION_TRANSACTIONS_ALL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
DEDUCTION_REQ_ID NUMBER (15) Yes
DEDUCTION_REQ_TRAN_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
TASK_ID NUMBER (15) Yes
EXPENDITURE_TYPE VARCHAR2 (30) Yes
EXPENDITURE_ORG_ID NUMBER (15) Yes
QUANTITY NUMBER

OVERRIDE_QUANTITY NUMBER

EXPENDITURE_ITEM_ID NUMBER (15)
EXPENDITURE_ITEM_DATE DATE
Yes
GL_DATE DATE

PROJFUNC_CURRENCY_CODE VARCHAR2 (30)
ORIG_PROJFUNC_AMOUNT NUMBER

OVERRIDE_PROJFUNC_AMOUNT NUMBER

CONVERSION_RATETYPE VARCHAR2 (30)
CONVERSION_RATEDATE DATE

CONVERSION_RATE NUMBER

AMOUNT NUMBER
Yes
DESCRIPTION VARCHAR2 (4000)
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
,      DEDUCTION_REQ_TRAN_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORG_ID
,      QUANTITY
,      OVERRIDE_QUANTITY
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ITEM_DATE
,      GL_DATE
,      PROJFUNC_CURRENCY_CODE
,      ORIG_PROJFUNC_AMOUNT
,      OVERRIDE_PROJFUNC_AMOUNT
,      CONVERSION_RATETYPE
,      CONVERSION_RATEDATE
,      CONVERSION_RATE
,      AMOUNT
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATION_DATE
,      LAST_UPDATED_BY
FROM PA.PA_DEDUCTION_TRANSACTIONS_ALL#;

Dependencies

[top of page]

PA.PA_DEDUCTION_TRANSACTIONS_ALL# references the following:

SchemaPA
TablePA_DEDUCTION_TRANSACTIONS_ALL
PA.PA_DEDUCTION_TRANSACTIONS_ALL# is referenced by following:

SchemaAPPS
SynonymPA_DEDUCTION_TRANSACTIONS_ALL