[Home] [Help] [Dependency Information]
Object Name: | PA_COMMITMENT_TXNS_TMP |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_COMMITMENT_TXNS_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_COMMITMENT_TXNS_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 | |||
TRANSACTION_SOURCE | VARCHAR2 | (20) | ||
LINE_TYPE | VARCHAR2 | (1) | ||
CMT_NUMBER | VARCHAR2 | (50) | ||
CMT_DISTRIBUTION_ID | NUMBER | |||
CMT_HEADER_ID | NUMBER | |||
DESCRIPTION | VARCHAR2 | (240) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
PA_PERIOD | VARCHAR2 | (20) | ||
GL_PERIOD | VARCHAR2 | (15) | ||
CMT_LINE_NUMBER | NUMBER | |||
CMT_CREATION_DATE | DATE | |||
CMT_APPROVED_DATE | DATE | |||
CMT_REQUESTOR_NAME | VARCHAR2 | (240) | ||
CMT_BUYER_NAME | VARCHAR2 | (240) | ||
CMT_APPROVED_FLAG | VARCHAR2 | (1) | ||
CMT_PROMISED_DATE | DATE | |||
CMT_NEED_BY_DATE | DATE | |||
ORGANIZATION_ID | NUMBER | |||
VENDOR_ID | NUMBER | |||
VENDOR_NAME | VARCHAR2 | (240) | ||
EXPENDITURE_TYPE | VARCHAR2 | (4000) | ||
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | ||
REVENUE_CATEGORY | VARCHAR2 | (30) | ||
SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | (15) | ||
UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
UNIT_PRICE | NUMBER | |||
CMT_IND_COMPILED_SET_ID | NUMBER | |||
ACCT_RAW_COST | NUMBER | |||
ACCT_BURDENED_COST | NUMBER | |||
TOT_CMT_QUANTITY | 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_DELIVERY | NUMBER | |||
AMOUNT_OUTSTANDING_DELIVERY | NUMBER | |||
QUANTITY_OUTSTANDING_INVOICE | NUMBER | |||
AMOUNT_OUTSTANDING_INVOICE | NUMBER | |||
QUANTITY_OVERBILLED | NUMBER | |||
AMOUNT_OVERBILLED | NUMBER | |||
ORIGINAL_TXN_REFERENCE1 | VARCHAR2 | (100) | ||
ORIGINAL_TXN_REFERENCE2 | VARCHAR2 | (100) | ||
ORIGINAL_TXN_REFERENCE3 | VARCHAR2 | (100) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | ||
DENOM_RAW_COST | NUMBER | |||
DENOM_BURDENED_COST | NUMBER | |||
ACCT_CURRENCY_CODE | VARCHAR2 | (15) | ||
ACCT_RATE_DATE | DATE | |||
ACCT_RATE_TYPE | VARCHAR2 | (30) | ||
ACCT_EXCHANGE_RATE | NUMBER | |||
RECEIPT_CURRENCY_CODE | VARCHAR2 | (15) | ||
RECEIPT_CURRENCY_AMOUNT | NUMBER | |||
RECEIPT_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) | ||
RESOURCE_CLASS | VARCHAR2 | (18) |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, TASK_ID
, TRANSACTION_SOURCE
, LINE_TYPE
, CMT_NUMBER
, CMT_DISTRIBUTION_ID
, CMT_HEADER_ID
, DESCRIPTION
, EXPENDITURE_ITEM_DATE
, PA_PERIOD
, GL_PERIOD
, CMT_LINE_NUMBER
, CMT_CREATION_DATE
, CMT_APPROVED_DATE
, CMT_REQUESTOR_NAME
, CMT_BUYER_NAME
, CMT_APPROVED_FLAG
, CMT_PROMISED_DATE
, CMT_NEED_BY_DATE
, ORGANIZATION_ID
, VENDOR_ID
, VENDOR_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, SYSTEM_LINKAGE_FUNCTION
, UNIT_OF_MEASURE
, UNIT_PRICE
, CMT_IND_COMPILED_SET_ID
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, TOT_CMT_QUANTITY
, QUANTITY_ORDERED
, AMOUNT_ORDERED
, ORIGINAL_QUANTITY_ORDERED
, ORIGINAL_AMOUNT_ORDERED
, QUANTITY_CANCELLED
, AMOUNT_CANCELLED
, QUANTITY_DELIVERED
, QUANTITY_INVOICED
, AMOUNT_INVOICED
, QUANTITY_OUTSTANDING_DELIVERY
, AMOUNT_OUTSTANDING_DELIVERY
, QUANTITY_OUTSTANDING_INVOICE
, AMOUNT_OUTSTANDING_INVOICE
, QUANTITY_OVERBILLED
, AMOUNT_OVERBILLED
, ORIGINAL_TXN_REFERENCE1
, ORIGINAL_TXN_REFERENCE2
, ORIGINAL_TXN_REFERENCE3
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, RECEIPT_CURRENCY_CODE
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_EXCHANGE_RATE
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME
, UOM_CODE
, WIP_RESOURCE_ID
, WIP_RESOURCE_NAME
, RESOURCE_CLASS
FROM PA.PA_COMMITMENT_TXNS_TMP;
PA.PA_COMMITMENT_TXNS_TMP does not reference any database object
PA.PA_COMMITMENT_TXNS_TMP is referenced by following:
|
|
|