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_GL_UNCOST_EXCEPT_SUM_V

Object Details

Object Name:	PA_GL_UNCOST_EXCEPT_SUM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_GL_UNCOST_EXCEPT_SUM_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

PA_GL_UNCOST_EXCEPT_SUM_V is a view that identifies the Cost Distribution Lines that prevent a period

[View Source]

Columns

Name	Datatype	Length	Comments
PROJECT_ID	NUMBER	(15)
PROJECT_NAME	VARCHAR2	(30)
TASK_ID	NUMBER	(15)	Task Id
TASK_NAME	VARCHAR2	(20)
EXPENDITURE_ID	NUMBER	(15)	Expenditure Id
EXPENDITURE_ITEM_ID	NUMBER	(15)	Expenditure Item Id
EXPENDITURE_ITEM_DATE	DATE		Expenditure Item Date
EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure Type
EXP_ORGANIZATION_ID	NUMBER
EXP_ORG_NAME	VARCHAR2	(4000)
PERIOD_NAME	VARCHAR2	(15)	Period Name
PA_PERIOD_NAME	VARCHAR2	(20)
EXCEPTION_CODE	VARCHAR2	(30)
QUANTITY	NUMBER		Quantity
DENOM_CURRENCY_CODE	VARCHAR2	(15)	Denomination Currency code
DENOM_RAW_AMOUNT	NUMBER		Denomination raw cost
DENOM_BURDENED_AMOUNT	NUMBER
ACCT_CURRENCY_CODE	VARCHAR2	(15)	accounting Currency code
ACCT_RAW_AMOUNT	NUMBER
ACCT_BURDENED_AMOUNT	NUMBER
PROJECT_CURRENCY_CODE	VARCHAR2	(15)	Project Currency code
EXCEPTION_REASON	VARCHAR2	(4000)	Exception Reason
CORRECTIVE_ACTION	VARCHAR2	(4000)	Corrective Action
ORG_ID	NUMBER	(15)
SAME_PA_GL_PERIOD	VARCHAR2	(1)
OU_NAME	VARCHAR2	(4000)	Operating Unit Name
SET_OF_BOOKS_ID	NUMBER	(15)	Set of books Identifier
PERSON_NAME	VARCHAR2	(240)
PERSON_ID	NUMBER	(15)
EXPENDITURE_BATCH	VARCHAR2	(240)
VENDOR_ID	VARCHAR2	(30)
VENDOR_NAME	VARCHAR2	(240)
VENDOR_NUMBER	VARCHAR2	(30)
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)
PRVDR_ACCRUAL_DATE	DATE

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NAME
,      TASK_ID
,      TASK_NAME
,      EXPENDITURE_ID
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_TYPE
,      EXP_ORGANIZATION_ID
,      EXP_ORG_NAME
,      PERIOD_NAME
,      PA_PERIOD_NAME
,      EXCEPTION_CODE
,      QUANTITY
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_AMOUNT
,      DENOM_BURDENED_AMOUNT
,      ACCT_CURRENCY_CODE
,      ACCT_RAW_AMOUNT
,      ACCT_BURDENED_AMOUNT
,      PROJECT_CURRENCY_CODE
,      EXCEPTION_REASON
,      CORRECTIVE_ACTION
,      ORG_ID
,      SAME_PA_GL_PERIOD
,      OU_NAME
,      SET_OF_BOOKS_ID
,      PERSON_NAME
,      PERSON_ID
,      EXPENDITURE_BATCH
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_NUMBER
,      SYSTEM_LINKAGE_FUNCTION
,      PRVDR_ACCRUAL_DATE
FROM APPS.PA_GL_UNCOST_EXCEPT_SUM_V;

Dependencies

[top of page]

APPS.PA_GL_UNCOST_EXCEPT_SUM_V references the following:

APPS: GL_PERIOD_STATUSES; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PA_COST_DISTRIBUTION_LINES_ALL; PA_EXCEPTION_REASONS_PUB - show dependent code; PA_EXPENDITURES_ALL; PA_EXPENDITURES_UTILS - show dependent code; PA_EXPENDITURE_ITEMS_ALL; PA_IMPLEMENTATIONS_ALL; PA_PERIODS_ALL; PA_PROJECTS_ALL; PA_TASKS; PER_PEOPLE_F; PO_VENDORS

APPS.PA_GL_UNCOST_EXCEPT_SUM_V is not referenced by any database object