[Home] [Help] [Dependency Information]
Object Name: | PA_FC_COMMITMENT_DTLS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | ||
PROJECT_NAME | VARCHAR2 | (25) | ||
TASK_ID | NUMBER | (15) | ||
SUPPLIER_NAME | VARCHAR2 | (240) | ||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_NUMBER | VARCHAR2 | (30) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
COMMITMENT_TYPE_CODE | VARCHAR2 | (10) | ||
COMMITMENT_TYPE | VARCHAR2 | (80) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
DOCUMENT_NUMBER | VARCHAR2 | (50) | ||
LINE_NUMBER | NUMBER | |||
DISTRIBUTION_NUMBER | NUMBER | |||
TASK_NUMBER | VARCHAR2 | (25) | ||
TXN_COMMITMENT_AMT | NUMBER | |||
TXN_CURRENCY | VARCHAR2 | (15) | ||
FUNC_COMMITMENT_AMT | NUMBER | |||
FUNC_CURRENCY | VARCHAR2 | (15) | ||
PROJECT_CURRENCY | VARCHAR2 | (15) | ||
PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_RATE_DATE | DATE | |||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJFUNC_COST_RATE_DATE | DATE | |||
PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
AS_OF_PERIOD | VARCHAR2 | (15) | ||
GL_DATE | DATE | |||
PA_DATE | DATE | |||
ORG_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NAME
, TASK_ID
, SUPPLIER_NAME
, SUPPLIER_ID
, SUPPLIER_NUMBER
, EXPENDITURE_ITEM_DATE
, COMMITMENT_TYPE_CODE
, COMMITMENT_TYPE
, EXPENDITURE_TYPE
, DOCUMENT_NUMBER
, LINE_NUMBER
, DISTRIBUTION_NUMBER
, TASK_NUMBER
, TXN_COMMITMENT_AMT
, TXN_CURRENCY
, FUNC_COMMITMENT_AMT
, FUNC_CURRENCY
, PROJECT_CURRENCY
, PROJECT_RATE_TYPE
, PROJECT_RATE_DATE
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_RATE_TYPE
, AS_OF_PERIOD
, GL_DATE
, PA_DATE
, ORG_ID
FROM APPS.PA_FC_COMMITMENT_DTLS_V;
APPS.PA_FC_COMMITMENT_DTLS_V is not referenced by any database object
|
|
|