[Home] [Help] [Dependency Information]
Object Name: | PA_GL_CC_EXCEPT_SUM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_GL_CC_EXCEPT_SUM_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Summary of cross charge distributions that prevent a period from being closed.
This view is used in period close reports. It shows a summary all cross charge distribution lines that prevent closing a period.
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. | ||
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. | |
VENDOR_ID | NUMBER | Vendor Id. | ||
NON_LABOR_ORG_ID | NUMBER | (15) | Non-Labor Org Id. | |
EXPND_ORG_ID | NUMBER | Expenditure Org Id. | ||
EXPENDITURE_ID | NUMBER | (15) | Expenditure Id. | |
EXPENDITURE_ITEM_ID | NUMBER | (15) | Expenditure Item Id. | |
EXPENDITURE_ITEM_DATE | DATE | Expenditure Item Id | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | Expenditure Type. | |
CDL_LINE_NUM | NUMBER | Line Number. | ||
GL_DATE | DATE | PA Date. | ||
PERIOD_NAME | VARCHAR2 | (15) | Period Name. | |
ACCT_CURRENCY_CODE | VARCHAR2 | (15) | Accounting 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. | |
CCD_EXCEPTION_TYPE | CHAR | (1) | Exception Type. | |
ORG_ID | NUMBER | ORG ID | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NUMBER
, TASK_ID
, RECVR_ORG_ID
, RECVR_ORG_NAME
, EMPLOYEE_ID
, VENDOR_ID
, NON_LABOR_ORG_ID
, EXPND_ORG_ID
, 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
, CCD_EXCEPTION_TYPE
, ORG_ID
, SAME_PA_GL_PERIOD
, OU_NAME
, SET_OF_BOOKS_ID
FROM APPS.PA_GL_CC_EXCEPT_SUM_V;
|
|
|