[Home] [Help] [Dependency Information]
Object Name: | PO_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 | ||
PO_DISTRIBUTION_ID | NUMBER | Distribution Id | ||
PO_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Distribution Type | |
PO_LINE_LOCATION_ID | NUMBER | Unique Shipment Identifier | ||
PO_LINE_ID | VARCHAR2 | (40) | Purchase Order Line Identifier | |
REQ_LINE_ID | NUMBER | Requisition Line Identifier | ||
DISTRIBUTION_LINK_TYPE | VARCHAR2 | (24) | This contains the Table name from which this row is being fetched | |
MAIN_OR_BACKING_CODE | VARCHAR2 | (30) | main dist or backing dist | |
BUDGET_ACCOUNT | NUMBER | Yes | Budget Account | |
CURRENCY_CODE | VARCHAR2 | (30) | Yes | Currency Code |
ENTERED_AMT | NUMBER | Yes | Entered Amount | |
ACCOUNTED_AMT | NUMBER | Yes | Accounted Amount | |
BACKING_DIST_ENTERED_AMT | NUMBER | Backing Reference�s Entered Amount | ||
BACKING_DIST_ACCOUNTED_AMT | NUMBER | Backing Reference�s Accounted Amount | ||
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 | Backing Reference Header Id 1 (Applied to System Trans Id 1) | ||
APPLIED_TO_DIST_LINK_TYPE | VARCHAR2 | (30) | Backing Reference Dsitribution 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) | ||
ALLOC_TO_DIST_ID_1 | NUMBER | Allocated to main document distribution identifier | ||
ACCOUNTING_REVERSAL_FLAG | CHAR | (1) | This contains a value N always | |
ADJUSTMENT_STATUS | VARCHAR2 | (5) | Adjustment Status | |
PO_ENCUM_UPG_OPTION | VARCHAR2 | (4000) | Indicates if an accounting info of an entity (Req/PO/Release) is upgraded to SLA Tables or not | |
PA_PROJECT_ID | NUMBER | Project Id | ||
PA_AWARD_ID | NUMBER | Award Id | ||
PA_TASK_ID | NUMBER | 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 | ||
BACKING_REQ_ENC_CHANGED | VARCHAR2 | (4000) | Backing requisition encumbrance changed flag | |
ALLOC_TO_DISTRIBUTION_TYPE | CHAR | (20) | this column stores the value 'PO_DISTRIBUTIONS_ALL'(hardcoded) to indicate that the backing row is pointing to main row. | |
PO_UPG_ENC_TYPE_ID | NUMBER | (15) | Yes | Enc type : This stores value of 1000 for reqs and 1001 for the rest |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, LINE_NUMBER
, PO_DISTRIBUTION_ID
, PO_DISTRIBUTION_TYPE
, PO_LINE_LOCATION_ID
, PO_LINE_ID
, REQ_LINE_ID
, DISTRIBUTION_LINK_TYPE
, MAIN_OR_BACKING_CODE
, BUDGET_ACCOUNT
, CURRENCY_CODE
, ENTERED_AMT
, ACCOUNTED_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
, ALLOC_TO_DIST_ID_1
, ACCOUNTING_REVERSAL_FLAG
, ADJUSTMENT_STATUS
, PO_ENCUM_UPG_OPTION
, PA_PROJECT_ID
, PA_AWARD_ID
, PA_TASK_ID
, PA_EXP_ORG_ID
, PA_EXP_TYPE
, PA_EXP_ITEM_DATE
, BACKING_REQ_ENC_CHANGED
, ALLOC_TO_DISTRIBUTION_TYPE
, PO_UPG_ENC_TYPE_ID
FROM APPS.PO_EXTRACT_DETAIL_V;
|
|
|