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

VIEW: APPS.PO_EXTRACT_DETAIL_V

Object Details
Object Name: PO_EXTRACT_DETAIL_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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

Enc type : This stores value of 1000 for reqs and 1001 for the rest
Query Text

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;

Dependencies

[top of page]

APPS.PO_EXTRACT_DETAIL_V references the following:

SchemaAPPS
SynonymPO_BC_DISTRIBUTIONS
PL/SQL PackagePO_DOCUMENT_FUNDS_PVT - show dependent code
PL/SQL PackagePSA_BC_XLA_PUB - show dependent code
SynonymXLA_EVENTS_GT
APPS.PO_EXTRACT_DETAIL_V is referenced by following:

SchemaAPPS
Package BodyFV_SLA_PROCESSING_PKG - show dependent code
Package BodyXLA_00201_AAD_S_000004_BC_PKG - show dependent code
Package BodyXLA_00201_AAD_S_000005_BC_PKG - show dependent code