[Home] [Help] [Dependency Information]
Object Name: | PA_PJM_REQ_COMMITMENTS_TMP |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_PJM_REQ_COMMITMENTS_TMP |
Subobject Name: | |
Status: | VALID |
This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a global temporary table.
PA.PA_PJM_REQ_COMMITMENTS_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
REQ_NUMBER | VARCHAR2 | (50) | ||
REQ_DISTRIBUTION_ID | NUMBER | |||
REQUISITION_HEADER_ID | NUMBER | |||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
REQ_LINE | NUMBER | |||
CREATION_DATE | DATE | |||
REQUESTOR_NAME | VARCHAR2 | (240) | ||
APPROVED_FLAG | VARCHAR2 | (1) | ||
NEED_BY_DATE | DATE | |||
EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
VENDOR_ID | NUMBER | |||
VENDOR_NAME | VARCHAR2 | (240) | ||
EXPENDITURE_TYPE | VARCHAR2 | (4000) | ||
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | ||
REVENUE_CATEGORY | VARCHAR2 | (30) | ||
UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
UNIT_PRICE | NUMBER | |||
AMOUNT | NUMBER | |||
QUANTITY | NUMBER | |||
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | ||
DENOM_AMOUNT | NUMBER | |||
ACCT_CURRENCY_CODE | VARCHAR2 | (15) | ||
ACCT_RATE_DATE | DATE | |||
ACCT_RATE_TYPE | VARCHAR2 | (30) | ||
ACCT_EXCHANGE_RATE | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
INVENTORY_ITEM_NAME | VARCHAR2 | (40) | ||
UOM_CODE | VARCHAR2 | (25) | ||
WIP_RESOURCE_ID | NUMBER | |||
WIP_RESOURCE_NAME | VARCHAR2 | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, TASK_ID
, REQ_NUMBER
, REQ_DISTRIBUTION_ID
, REQUISITION_HEADER_ID
, ITEM_DESCRIPTION
, EXPENDITURE_ITEM_DATE
, REQ_LINE
, CREATION_DATE
, REQUESTOR_NAME
, APPROVED_FLAG
, NEED_BY_DATE
, EXPENDITURE_ORGANIZATION_ID
, VENDOR_ID
, VENDOR_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, UNIT_OF_MEASURE
, UNIT_PRICE
, AMOUNT
, QUANTITY
, DENOM_CURRENCY_CODE
, DENOM_AMOUNT
, ACCT_CURRENCY_CODE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME
, UOM_CODE
, WIP_RESOURCE_ID
, WIP_RESOURCE_NAME
FROM PA.PA_PJM_REQ_COMMITMENTS_TMP;
PA.PA_PJM_REQ_COMMITMENTS_TMP does not reference any database object
PA.PA_PJM_REQ_COMMITMENTS_TMP is referenced by following:
|
|
|