[Home] [Help] [Dependency Information]
Object Name: | PA_PJM_PO_COMMITMENTS_TMP |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_PJM_PO_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_PO_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 | |||
PO_NUMBER | VARCHAR2 | (50) | ||
PO_DISTRIBUTION_ID | NUMBER | |||
PO_HEADER_ID | NUMBER | |||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
PO_LINE | NUMBER | |||
CREATION_DATE | DATE | |||
APPROVED_DATE | DATE | |||
REQUESTOR_NAME | VARCHAR2 | (240) | ||
BUYER_NAME | VARCHAR2 | (240) | ||
APPROVED_FLAG | VARCHAR2 | (1) | ||
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_OUTSTANDING_DELIVERY | NUMBER | |||
QUANTITY_OUTSTANDING_DELIVERY | NUMBER | |||
QUANTITY_ORDERED | NUMBER | |||
AMOUNT_ORDERED | NUMBER | |||
ORIGINAL_QUANTITY_ORDERED | NUMBER | |||
ORIGINAL_AMOUNT_ORDERED | NUMBER | |||
QUANTITY_CANCELLED | NUMBER | |||
AMOUNT_CANCELLED | NUMBER | |||
QUANTITY_DELIVERED | NUMBER | |||
QUANTITY_INVOICED | NUMBER | |||
AMOUNT_INVOICED | NUMBER | |||
QUANTITY_OUTSTANDING_INVOICE | NUMBER | |||
AMOUNT_OUTSTANDING_INVOICE | NUMBER | |||
QUANTITY_OVERBILLED | NUMBER | |||
AMOUNT_OVERBILLED | NUMBER | |||
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | ||
DENOM_AMT_OUTSTANDING_DELIVERY | 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
, PO_NUMBER
, PO_DISTRIBUTION_ID
, PO_HEADER_ID
, ITEM_DESCRIPTION
, EXPENDITURE_ITEM_DATE
, PO_LINE
, CREATION_DATE
, APPROVED_DATE
, REQUESTOR_NAME
, BUYER_NAME
, APPROVED_FLAG
, EXPENDITURE_ORGANIZATION_ID
, VENDOR_ID
, VENDOR_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, UNIT_OF_MEASURE
, UNIT_PRICE
, AMOUNT_OUTSTANDING_DELIVERY
, QUANTITY_OUTSTANDING_DELIVERY
, QUANTITY_ORDERED
, AMOUNT_ORDERED
, ORIGINAL_QUANTITY_ORDERED
, ORIGINAL_AMOUNT_ORDERED
, QUANTITY_CANCELLED
, AMOUNT_CANCELLED
, QUANTITY_DELIVERED
, QUANTITY_INVOICED
, AMOUNT_INVOICED
, QUANTITY_OUTSTANDING_INVOICE
, AMOUNT_OUTSTANDING_INVOICE
, QUANTITY_OVERBILLED
, AMOUNT_OVERBILLED
, DENOM_CURRENCY_CODE
, DENOM_AMT_OUTSTANDING_DELIVERY
, 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_PO_COMMITMENTS_TMP;
PA.PA_PJM_PO_COMMITMENTS_TMP does not reference any database object
PA.PA_PJM_PO_COMMITMENTS_TMP is referenced by following:
|
|
|