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 Id
PROJECT_NAME	VARCHAR2	(30)	Project Name
TASK_ID	NUMBER	(15)	Task Id
TASK_NAME	VARCHAR2	(20)	Task Name
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 Organization Id
EXP_ORG_NAME	VARCHAR2	(4000)	EXP ORG NAME
PERIOD_NAME	VARCHAR2	(15)	Period Name
EXCEPTION_CODE	VARCHAR2	(30)	Exception Code
QUANTITY	NUMBER		Quantity
DENOM_CURRENCY_CODE	VARCHAR2	(15)	Denomination Currency code
DENOM_RAW_AMOUNT	NUMBER		Denomination raw cost
DENOM_BURDENED_AMOUNT	NUMBER		Denomination Burdened Amount
ACCT_CURRENCY_CODE	VARCHAR2	(15)	accounting Currency code
ACCT_RAW_AMOUNT	NUMBER		Accounting Raw Amount
ACCT_BURDENED_AMOUNT	NUMBER		Accounting Burdened Amount
PROJECT_CURRENCY_CODE	VARCHAR2	(15)	Project Currency code
EXCEPTION_REASON	VARCHAR2	(4000)	Exception Reason
CORRECTIVE_ACTION	VARCHAR2	(4000)	Corrective Action
ORG_ID	NUMBER	(15)	ORG ID
SAME_PA_GL_PERIOD	VARCHAR2	(1)	SAME PA GL PERIOD
OU_NAME	VARCHAR2	(4000)	Operating Unit Name
SET_OF_BOOKS_ID	NUMBER	(15)	Set of books Identifier
PERSON_NAME	VARCHAR2	(240)	Person Name
PERSON_ID	NUMBER	(15)	Person Id
EXPENDITURE_BATCH	VARCHAR2	(240)	Expenditure Batch
VENDOR_ID	VARCHAR2	(30)	Vendor Id
VENDOR_NAME	VARCHAR2	(240)	Vendor Name
VENDOR_NUMBER	VARCHAR2	(30)	Vendor Number
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)	System Linkage Function
PRVDR_ACCRUAL_DATE	DATE		PRVDR ACCRUAL 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
,      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_LOOKUPS; PA_PROJECTS_ALL; PA_TASKS; PER_PEOPLE_F; PO_VENDORS

APPS.PA_GL_UNCOST_EXCEPT_SUM_V is not referenced by any database object