[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) | ||
EXPENDITURE_ID | NUMBER | (15) | ||
EXPENDITURE_ITEM_ID | NUMBER | (15) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
CDL_LINE_NUM | NUMBER | (15) | ||
GL_DATE | DATE | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
TRANSFER_STATUS_CODE | VARCHAR2 | (1) | ||
TRANSFER_REJECTION_REASON | VARCHAR2 | (250) | ||
QUANTITY | NUMBER | |||
AMOUNT | NUMBER | |||
DENOM_AMOUNT | NUMBER | |||
PROJECT_AMOUNT | NUMBER | |||
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | ||
VENDOR_ID | NUMBER | |||
INVOICE_ID | NUMBER | (15) | ||
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | ||
INVOICE_LINE_NUMBER | NUMBER | (15) | ||
INVOICE_PAYMENT_ID | NUMBER | (15) | ||
DOCUMENT_TYPE | VARCHAR2 | (30) | ||
DOCUMENT_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
SI_ASSETS_ADDITION_FLAG | VARCHAR2 | (1) | ||
EXCEPTION_REASON | VARCHAR2 | (4000) | ||
CORRECTIVE_ACTION | VARCHAR2 | (4000) | ||
CDL_EXCEPTION_TYPE | VARCHAR2 | (1) | ||
ORG_ID | NUMBER | (15) | ||
SAME_PA_GL_PERIOD | VARCHAR2 | (1) | ||
OU_NAME | VARCHAR2 | (4000) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
UNIT_OF_MEASURE | VARCHAR2 | (30) |
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;
|
|
|