eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_XLA_BC_PKT_AP_DETAIL_V

Object Details

Object Name:	PA_XLA_BC_PKT_AP_DETAIL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_XLA_BC_PKT_AP_DETAIL_V
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
EVENT_ID	NUMBER	(15)
SOURCE_EVENT_ID	NUMBER	(15)
LINE_NUMBER	NUMBER	(15)	Yes
AID_INVOICE_DIST_ID	NUMBER	(15)	Yes
AID_EXPENDITURE_TYPE	VARCHAR2	(30)	Yes
BC_PACKET_ID	NUMBER	(15)	Yes
BUDGET_VERSION_ID	NUMBER	(15)	Yes
AID_BASE_AMT_NO_ROUND	NUMBER
AID_AMOUNT	NUMBER
DISTRIBUTION_LINK_TYPE	VARCHAR2	(12)
AID_PROJECT_ID	NUMBER	(15)	Yes
AID_TASK_ID	NUMBER	(15)	Yes
AID_EXPENDITURE_ORG_ID	NUMBER	(15)	Yes
AID_EXPENDITURE_ITEM_DATE	DATE		Yes
UPG_ENC_TYPE_ID	NUMBER	(15)
UPG_PROJ_ENC_TYPE_ID	NUMBER	(15)
AI_INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes
LEDGER_CURRENCY	VARCHAR2	(15)	Yes
INV_EXCHANGE_RATE_TYPE	VARCHAR2	(0)
INV_EXCHANGE_DATE	DATE
INV_EXCHANGE_RATE	NUMBER
BUDGET_CCID	NUMBER	(15)
DOCUMENT_TYPE	VARCHAR2	(10)	Yes
AI_INVOICE_ID	NUMBER	(15)	Yes
REV_EVENT_TYPE	VARCHAR2	(30)
EXPENDITURE_CATEGORY	VARCHAR2	(30)
REVENUE_CATEGORY	VARCHAR2	(30)
PERSON_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
POV_VENDOR_ID	NUMBER	(15)
PACKET_ID	NUMBER	(15)	Yes
PARENT_BC_PACKET_ID	NUMBER	(15)
LEDGER_ID	NUMBER	(15)	Yes
BURDEN_COST_FLAG	VARCHAR2	(1)	Yes
USE_ENC_UPG_ATTRIB_FLAG	VARCHAR2	(4000)
ENC_UPG_DR_ACCT_CLASS	VARCHAR2	(18)
ENC_UPG_CR_ACCT_CLASS	VARCHAR2	(18)
ENC_UPG_DR_ACCOUNT	NUMBER	(15)
ENC_UPG_CR_ACCOUNT	NUMBER	(15)
ENC_UPG_DR_ENC_TYPE_ID	NUMBER
ENC_UPG_CR_ENC_TYPE_ID	NUMBER
PO_APPLICATION_ID	NUMBER
PO_DISTRIBUTION_TYPE	VARCHAR2	(12)
PO_ENTITY_CODE	VARCHAR2	(14)
PO_FIRST_DIST_ID	NUMBER
PO_SECOND_DIST_ID	VARCHAR2	(30)
PO_FIRST_SYS_TRANS_ID	NUMBER
AP_APPLICATION_ID	NUMBER
AP_DISTRIBUTION_TYPE	VARCHAR2	(12)
AP_ENTITY_CODE	VARCHAR2	(11)
AP_FIRST_DIST_ID	NUMBER
AP_SECOND_DIST_ID	VARCHAR2	(30)
AP_FIRST_SYS_TRANS_ID	NUMBER
PA_APPLICATION_ID	NUMBER
PA_DISTRIBUTION_TYPE	CHAR	(13)
PA_ENTITY_CODE	CHAR	(7)
PA_FIRST_DIST_ID	NUMBER	(15)
PA_SECOND_DIST_ID	VARCHAR2	(0)
PA_FIRST_SYS_TRANS_ID	NUMBER	(15)	Yes
ALLOC_TO_APPLN_ID	NUMBER
ALLOC_TO_DIST_TYPE	VARCHAR2	(11)
ALLOC_TO_ENTITY_CODE	CHAR	(11)
ALLOC_TO_FIRST_SYS_TRANS_ID	NUMBER
ALLOC_TO_FIRST_DIST_ID	NUMBER
ALLOC_TO_SECOND_DIST_ID	VARCHAR2	(0)
PO_RELEASE_ID	NUMBER
DOCUMENT_DISTRIBUTION_TYPE	VARCHAR2	(30)
AID_DIST_CCID	NUMBER	(15)
ACCT_REVERSAL_INDICATOR	VARCHAR2	(1)
ACCT_REVERSAL_FIRST_DIST_ID	NUMBER
ACCT_REV_DISTRIBUTION_TYPE	VARCHAR2	(12)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_ID
,      SOURCE_EVENT_ID
,      LINE_NUMBER
,      AID_INVOICE_DIST_ID
,      AID_EXPENDITURE_TYPE
,      BC_PACKET_ID
,      BUDGET_VERSION_ID
,      AID_BASE_AMT_NO_ROUND
,      AID_AMOUNT
,      DISTRIBUTION_LINK_TYPE
,      AID_PROJECT_ID
,      AID_TASK_ID
,      AID_EXPENDITURE_ORG_ID
,      AID_EXPENDITURE_ITEM_DATE
,      UPG_ENC_TYPE_ID
,      UPG_PROJ_ENC_TYPE_ID
,      AI_INVOICE_CURRENCY_CODE
,      LEDGER_CURRENCY
,      INV_EXCHANGE_RATE_TYPE
,      INV_EXCHANGE_DATE
,      INV_EXCHANGE_RATE
,      BUDGET_CCID
,      DOCUMENT_TYPE
,      AI_INVOICE_ID
,      REV_EVENT_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      PERSON_ID
,      JOB_ID
,      POV_VENDOR_ID
,      PACKET_ID
,      PARENT_BC_PACKET_ID
,      LEDGER_ID
,      BURDEN_COST_FLAG
,      USE_ENC_UPG_ATTRIB_FLAG
,      ENC_UPG_DR_ACCT_CLASS
,      ENC_UPG_CR_ACCT_CLASS
,      ENC_UPG_DR_ACCOUNT
,      ENC_UPG_CR_ACCOUNT
,      ENC_UPG_DR_ENC_TYPE_ID
,      ENC_UPG_CR_ENC_TYPE_ID
,      PO_APPLICATION_ID
,      PO_DISTRIBUTION_TYPE
,      PO_ENTITY_CODE
,      PO_FIRST_DIST_ID
,      PO_SECOND_DIST_ID
,      PO_FIRST_SYS_TRANS_ID
,      AP_APPLICATION_ID
,      AP_DISTRIBUTION_TYPE
,      AP_ENTITY_CODE
,      AP_FIRST_DIST_ID
,      AP_SECOND_DIST_ID
,      AP_FIRST_SYS_TRANS_ID
,      PA_APPLICATION_ID
,      PA_DISTRIBUTION_TYPE
,      PA_ENTITY_CODE
,      PA_FIRST_DIST_ID
,      PA_SECOND_DIST_ID
,      PA_FIRST_SYS_TRANS_ID
,      ALLOC_TO_APPLN_ID
,      ALLOC_TO_DIST_TYPE
,      ALLOC_TO_ENTITY_CODE
,      ALLOC_TO_FIRST_SYS_TRANS_ID
,      ALLOC_TO_FIRST_DIST_ID
,      ALLOC_TO_SECOND_DIST_ID
,      PO_RELEASE_ID
,      DOCUMENT_DISTRIBUTION_TYPE
,      AID_DIST_CCID
,      ACCT_REVERSAL_INDICATOR
,      ACCT_REVERSAL_FIRST_DIST_ID
,      ACCT_REV_DISTRIBUTION_TYPE
FROM APPS.PA_XLA_BC_PKT_AP_DETAIL_V;