[Home] [Help] [Dependency Information]
Object Name: | PO_REQ_EXTRACT_DETAIL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | Accounting Event Id | ||
LINE_NUMBER | NUMBER | Line Number | ||
REQ_LINE_ID | NUMBER | Uniqe Line identifier | ||
REQ_DISTRIBUTION_ID | NUMBER | Distribution Id | ||
REQ_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Distribution Type | |
DISTRIBUTION_LINK_TYPE | CHAR | (24) | Indicates if an accounting info of an entity (Req/PO/Release) is upgraded to SLA Tables or not | |
MAIN_OR_BACKING_CODE | VARCHAR2 | (30) | main dist or backing dist | |
BUDGET_ACCOUNT | NUMBER | Yes | Budget Account | |
CURRENCY_CODE | VARCHAR2 | (30) | Yes | Currency Code |
ACCOUNTED_AMT | NUMBER | Yes | Accounted Amount | |
ENTERED_AMT | NUMBER | Yes | Entered Amount | |
BACKING_DIST_ENTERED_AMT | NUMBER | PYA original entered amount | ||
BACKING_DIST_ACCOUNTED_AMT | NUMBER | PYA original accounted amt | ||
JE_LINE_DESCRIPTION | VARCHAR2 | (240) | Journal Entry line description | |
JFMIP_REFERENCE | VARCHAR2 | (100) | REFERENCE10 | |
APPLIED_TO_APPL_ID | NUMBER | Applied to Application Id | ||
APPLIED_TO_ENTITY_CODE | VARCHAR2 | (25) | APPLIED_TO_ENTITY_CODE | |
APPLIED_TO_HEADER_ID_1 | NUMBER | APPLIED_TO_HEADER_ID_1 | ||
APPLIED_TO_DIST_LINK_TYPE | VARCHAR2 | (30) | Backing Reference Distribution Type | |
APPLIED_TO_DIST_ID_1 | NUMBER | Backing Reference Distribution ID 1(Applied to First Distribution Identifier) | ||
APPLIED_TO_DIST_ID_2 | NUMBER | Backing Reference Distribution Id 2(Applied to Second Distribution Identifier | ||
APPLIED_TO_DIST_ID_3 | NUMBER | Backing Reference Distribution Id 3(Applied to Third Distribution Identifier) | ||
APPLIED_TO_DIST_ID_4 | NUMBER | Backing Reference Distribution Id 4 (Applied to Fourth Distribution Identifier) | ||
APPLIED_TO_DIST_ID_5 | NUMBER | Backing Reference Distribution Id 5(Applied to Fifth Distribution Identifier) | ||
ACCOUNTING_REVERSAL_FLAG | CHAR | (1) | This contains value N always | |
ADJUSTMENT_STATUS | VARCHAR2 | (5) | Adjustment Status | |
REQ_ENCUM_UPG_OPTION | VARCHAR2 | (4000) | Adjustment Status | |
PA_PROJECT_ID | NUMBER | PA PROJECT ID | ||
PA_AWARD_ID | NUMBER | PA AWARD ID | ||
PA_TASK_ID | NUMBER | PA TASK ID | ||
PA_EXP_ORG_ID | NUMBER | Expenditure Organization Id | ||
PA_EXP_TYPE | VARCHAR2 | (30) | Expenditure Type | |
PA_EXP_ITEM_DATE | DATE | Expenditure Item Date | ||
REQ_UPG_ENC_TYPE_ID | NUMBER | (15) | Yes | Enc type : This stores value of 1000 (hard coded) |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, LINE_NUMBER
, REQ_LINE_ID
, REQ_DISTRIBUTION_ID
, REQ_DISTRIBUTION_TYPE
, DISTRIBUTION_LINK_TYPE
, MAIN_OR_BACKING_CODE
, BUDGET_ACCOUNT
, CURRENCY_CODE
, ACCOUNTED_AMT
, ENTERED_AMT
, BACKING_DIST_ENTERED_AMT
, BACKING_DIST_ACCOUNTED_AMT
, JE_LINE_DESCRIPTION
, JFMIP_REFERENCE
, APPLIED_TO_APPL_ID
, APPLIED_TO_ENTITY_CODE
, APPLIED_TO_HEADER_ID_1
, APPLIED_TO_DIST_LINK_TYPE
, APPLIED_TO_DIST_ID_1
, APPLIED_TO_DIST_ID_2
, APPLIED_TO_DIST_ID_3
, APPLIED_TO_DIST_ID_4
, APPLIED_TO_DIST_ID_5
, ACCOUNTING_REVERSAL_FLAG
, ADJUSTMENT_STATUS
, REQ_ENCUM_UPG_OPTION
, PA_PROJECT_ID
, PA_AWARD_ID
, PA_TASK_ID
, PA_EXP_ORG_ID
, PA_EXP_TYPE
, PA_EXP_ITEM_DATE
, REQ_UPG_ENC_TYPE_ID
FROM APPS.PO_REQ_EXTRACT_DETAIL_V;
|
|
|