[Home] [Help] [Dependency Information]
Object Name: | PA_CC_EXCEPTIONS_DET_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_CC_EXCEPTIONS_DET_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is in period close reports. It shows the details of 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. | ||
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 Org Id. | |
NON_LABOR_ORG_NAME | VARCHAR2 | (240) | Non-Labor Org Name. | |
EXPND_ORG_ID | NUMBER | Expenditure Org Id. | ||
EXPND_ORG_NAME | VARCHAR2 | (240) | 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. | ||
PA_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. |
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
, PA_DATE
, PERIOD_NAME
, ACCT_CURRENCY_CODE
, AMOUNT
, EXCEPTION_REASON
, CORRECTIVE_ACTION
, EXCEPTION_CODE
, SYSTEM_LINKAGE_FUNCTION
FROM APPS.PA_CC_EXCEPTIONS_DET_V;
APPS.PA_CC_EXCEPTIONS_DET_V is not referenced by any database object
|
|
|