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

VIEW: APPS.PA_GL_CC_EXCEPT_DET_V

Object Details
Object Name: PA_GL_CC_EXCEPT_DET_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_GL_CC_EXCEPT_DET_V
Subobject Name:
Status: VALID

View Type

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


Cross charge distributions in the primary set of books that prevent a period from being closed.
This view is used in period close reports. It shows the details of all cross charge distribution lines in the primary set of books that prevent closing a period.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER

Project Id of the cross charge distribution.
PROJECT_NUMBER VARCHAR2 (25)
Project number of the cross charge distribution.
TASK_ID NUMBER

Task id of the cross charge distribution.
TASK_NUMBER VARCHAR2 (25) Yes Task number of the cross charge distribution.
RECVR_ORG_ID NUMBER

Receiver operating unit identifier of the cross charge distribution.
RECVR_ORG_NAME VARCHAR2 (240)
Receiver operating unit of the cross charge distribution.
EMPLOYEE_ID NUMBER (15)
Employee identifier of the cross charge distribution.
EMPLOYEE_NAME VARCHAR2 (240)
Employee name of the cross charge distribution.
VENDOR_ID NUMBER

Vendor Id.
VENDOR_NAME VARCHAR2 (240)
Vendor Name.
NON_LABOR_ORG_ID NUMBER (15)
Non-Labor Organization Id.
NON_LABOR_ORG_NAME VARCHAR2 (240)
Non-Labor Organization Name.
EXPND_ORG_ID NUMBER

Expenditure Organization Id.
EXPND_ORG_NAME VARCHAR2 (240)
Expenditure Organization Id.
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.
CDL_LINE_NUM NUMBER

Line Number.
GL_DATE DATE

GL Date.
PERIOD_NAME VARCHAR2 (15)
Period Name.
ACCT_CURRENCY_CODE VARCHAR2 (15)
Functional Currency Code.
AMOUNT NUMBER

Amount.
EXCEPTION_REASON VARCHAR2 (4000)
The reason for this transaction being in exception.
CORRECTIVE_ACTION VARCHAR2 (4000)
The corrective action to eliminate the exception.
EXCEPTION_CODE VARCHAR2 (50)
System defined code that classifies exception
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3)
Expenditure Type Class.
ORG_ID NUMBER

Operating Unit Identifier.
SAME_PA_GL_PERIOD VARCHAR2 (1)
Refer to base table.
OU_NAME VARCHAR2 (4000)
Operating Unit Name
SET_OF_BOOKS_ID NUMBER (15)
Set of Books identifier
Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      RECVR_ORG_ID
,      RECVR_ORG_NAME
,      EMPLOYEE_ID
,      EMPLOYEE_NAME
,      VENDOR_ID
,      VENDOR_NAME
,      NON_LABOR_ORG_ID
,      NON_LABOR_ORG_NAME
,      EXPND_ORG_ID
,      EXPND_ORG_NAME
,      EXPENDITURE_ID
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_TYPE
,      CDL_LINE_NUM
,      GL_DATE
,      PERIOD_NAME
,      ACCT_CURRENCY_CODE
,      AMOUNT
,      EXCEPTION_REASON
,      CORRECTIVE_ACTION
,      EXCEPTION_CODE
,      SYSTEM_LINKAGE_FUNCTION
,      ORG_ID
,      SAME_PA_GL_PERIOD
,      OU_NAME
,      SET_OF_BOOKS_ID
FROM APPS.PA_GL_CC_EXCEPT_DET_V;

Dependencies

[top of page]

APPS.PA_GL_CC_EXCEPT_DET_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPA_CC_DIST_LINES_ALL
SynonymPA_DRAFT_INVOICE_DETAILS_ALL
PL/SQL PackagePA_EXCEPTION_REASONS_PUB - show dependent code
PL/SQL PackagePA_EXPENDITURES_UTILS - show dependent code
ViewPA_GL_CC_EXCEPT_SUM_V
SynonymPA_TASKS
ViewPER_PEOPLE_F
ViewPO_VENDORS

APPS.PA_GL_CC_EXCEPT_DET_V is not referenced by any database object