[Home] [Help] [Dependency Information]
Object Name: | PA_GL_COST_EXCEPT_SUM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_GL_COST_EXCEPT_SUM_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PA_GL_COST_EXCEPT_SUM_V is a view that identifies the Cost Distribution Lines that prevent a period
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_ID | NUMBER | (15) | Yes | Task Id |
EXPENDITURE_ID | NUMBER | (15) | Yes | Expenditure Id |
EXPENDITURE_ITEM_ID | NUMBER | (15) | Yes | Expenditure Item Id |
EXPENDITURE_ITEM_DATE | DATE | Yes | Expenditure Item Date | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | Expenditure Type |
CDL_LINE_NUM | NUMBER | (15) | Yes | Cost Distribution Line Number |
GL_DATE | DATE | GL Date | ||
PERIOD_NAME | VARCHAR2 | (15) | Yes | Period Name |
TRANSFER_STATUS_CODE | VARCHAR2 | (1) | Yes | Transfer Status Code |
TRANSFER_REJECTION_REASON | VARCHAR2 | (250) | Transfer Rejection Reason | |
QUANTITY | NUMBER | (22) | Yes | Quantity |
AMOUNT | NUMBER | Amount | ||
DENOM_AMOUNT | NUMBER | Denomination Currency Amount | ||
PROJECT_AMOUNT | NUMBER | (22) | Yes | Project Currency Amount |
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | Denomination Currency Code | |
VENDOR_ID | NUMBER | (15) | Vendor Id | |
INVOICE_ID | NUMBER | (15) | Invoice Id | |
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Invoice Distribution Id | |
INVOICE_LINE_NUMBER | NUMBER | (15) | Invoice Line Number | |
INVOICE_PAYMENT_ID | NUMBER | (15) | Invoice Payment Id | |
DOCUMENT_TYPE | VARCHAR2 | (30) | Document Type | |
DOCUMENT_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Document Distribution Type | |
SI_ASSETS_ADDITION_FLAG | VARCHAR2 | (1) | SI ASSETS ADDITION FLAG | |
EXCEPTION_REASON | VARCHAR2 | (4000) | Exception Reason | |
CORRECTIVE_ACTION | VARCHAR2 | (4000) | Corrective Action | |
CDL_EXCEPTION_TYPE | VARCHAR2 | (1) | Cost Distribution Exception Type | |
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) | Yes | Set of books Identifier |
UNIT_OF_MEASURE | VARCHAR2 | (30) | Unit Of Measure |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_ID
, EXPENDITURE_ID
, EXPENDITURE_ITEM_ID
, EXPENDITURE_ITEM_DATE
, EXPENDITURE_TYPE
, CDL_LINE_NUM
, GL_DATE
, PERIOD_NAME
, TRANSFER_STATUS_CODE
, TRANSFER_REJECTION_REASON
, QUANTITY
, AMOUNT
, DENOM_AMOUNT
, PROJECT_AMOUNT
, DENOM_CURRENCY_CODE
, VENDOR_ID
, INVOICE_ID
, INVOICE_DISTRIBUTION_ID
, INVOICE_LINE_NUMBER
, INVOICE_PAYMENT_ID
, DOCUMENT_TYPE
, DOCUMENT_DISTRIBUTION_TYPE
, SI_ASSETS_ADDITION_FLAG
, EXCEPTION_REASON
, CORRECTIVE_ACTION
, CDL_EXCEPTION_TYPE
, ORG_ID
, SAME_PA_GL_PERIOD
, OU_NAME
, SET_OF_BOOKS_ID
, UNIT_OF_MEASURE
FROM APPS.PA_GL_COST_EXCEPT_SUM_V;
|
|
|