[Home] [Help] [Dependency Information]
Object Name: | PA_FI_AMOUNT_DTLS_TMP |
---|---|
Object Type: | TABLE |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Temporary table to populate records for the Transfer Price API.
PA.PA_FI_AMOUNT_DTLS_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 |
---|---|---|---|---|
FORECAST_ITEM_ID | NUMBER | Yes | ||
ITEM_DATE | DATE | Yes | ||
ITEM_UOM | VARCHAR2 | (30) | Yes | |
ITEM_QUANTITY | NUMBER | Yes | ||
COST_TXN_CURRENCY_CODE | VARCHAR2 | (15) | ||
REVENUE_TXN_CURRENCY_CODE | VARCHAR2 | (15) | ||
TXN_RAW_COST | NUMBER | |||
TXN_BURDENED_COST | NUMBER | |||
TXN_REVENUE | NUMBER | |||
TP_TXN_CURRENCY_CODE_IN | VARCHAR2 | (15) | ||
TP_TXN_CURRENCY_CODE_OUT | VARCHAR2 | (15) | ||
TXN_TRANSFER_PRICE | NUMBER | |||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_COST_RATE_DATE | DATE | |||
PROJECT_COST_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_COST_EXCHANGE_RATE | NUMBER | |||
PROJECT_RAW_COST | NUMBER | |||
PROJECT_BURDENED_COST | NUMBER | |||
PROJECT_REVENUE_RATE_DATE | DATE | |||
PROJECT_REVENUE_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_REVENUE_EXCHANGE_RATE | NUMBER | |||
PROJECT_REVENUE | NUMBER | |||
PROJECT_TP_RATE_DATE | DATE | |||
PROJECT_TP_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_TP_EXCHANGE_RATE | NUMBER | |||
PROJECT_TRANSFER_PRICE | NUMBER | |||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJFUNC_COST_RATE_DATE | DATE | |||
PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_COST_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_RAW_COST | NUMBER | |||
PROJFUNC_BURDENED_COST | NUMBER | |||
PROJFUNC_REVENUE_RATE_DATE | DATE | |||
PROJFUNC_REVENUE_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_REVENUE_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_REVENUE | NUMBER | |||
PROJFUNC_TP_RATE_DATE | DATE | |||
PROJFUNC_TP_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_TP_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_TRANSFER_PRICE | NUMBER | |||
EXPFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
EXPFUNC_COST_RATE_DATE | DATE | |||
EXPFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
EXPFUNC_COST_EXCHANGE_RATE | NUMBER | |||
EXPFUNC_RAW_COST | NUMBER | |||
EXPFUNC_BURDENED_COST | NUMBER | |||
EXPFUNC_TP_RATE_DATE | DATE | |||
EXPFUNC_TP_RATE_TYPE | VARCHAR2 | (30) | ||
EXPFUNC_TP_EXCHANGE_RATE | NUMBER | |||
EXPFUNC_TRANSFER_PRICE | NUMBER | |||
CC_PRVDR_ORG_ID | NUMBER | |||
CC_PRVDR_ORGANIZITION_ID | NUMBER | |||
CC_RECVR_ORG_ID | NUMBER | |||
CC_RECVR_ORGANIZITION_ID | NUMBER | |||
EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_TYPE_CLASS | VARCHAR2 | (30) | ||
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | ||
TP_LABOR_NL_FLAG | VARCHAR2 | (1) | ||
TP_TASK_ID | NUMBER | |||
TP_SCHEDULE_ID | NUMBER | |||
TP_REV_DISTRIBUTED_FLAG | VARCHAR2 | (1) | ||
TP_COMPUTE_FLAG | VARCHAR2 | (1) | ||
TP_FIXED_DATE | DATE | |||
PROJECT_ID | NUMBER | |||
PERSON_ID | NUMBER | |||
FORECAST_JOB_ID | NUMBER | |||
TP_NL_RESOURCE | VARCHAR2 | (30) | ||
TP_NL_RESOURCE_ORGZ_ID | NUMBER | |||
TP_PA_DATE | DATE | |||
TP_AMOUNT_TYPE | VARCHAR2 | (30) | ||
ASSIGNMENT_ID | NUMBER | |||
FI_PROCESS_FLAG | VARCHAR2 | (1) | ||
DELETE_FLAG | VARCHAR2 | (1) | ||
TP_ERROR_CODE | VARCHAR2 | (30) | ||
COST_REJECTION_CODE | VARCHAR2 | (30) | ||
REV_REJECTION_CODE | VARCHAR2 | (30) | ||
BURDEN_REJECTION_CODE | VARCHAR2 | (30) | ||
OTHER_REJECTION_CODE | VARCHAR2 | (30) | ||
TP_DENOM_RAW_COST | NUMBER | |||
TP_DENOM_BURDENED_COST | NUMBER | |||
TP_RAW_REVENUE | NUMBER | |||
TP_IND_COMPILED_SETID | NUMBER | |||
TP_BILL_RATE | NUMBER | |||
TP_BASE_AMOUNT | NUMBER | |||
TP_BILL_MARKUP_PERCENT | NUMBER | |||
TP_SCH_LINE_PERCENT | NUMBER | |||
TP_RULE_PERCENT | NUMBER | |||
TP_JOB_ID | NUMBER | |||
CC_MARKUP_BASECODE | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_ITEM_ID
, ITEM_DATE
, ITEM_UOM
, ITEM_QUANTITY
, COST_TXN_CURRENCY_CODE
, REVENUE_TXN_CURRENCY_CODE
, TXN_RAW_COST
, TXN_BURDENED_COST
, TXN_REVENUE
, TP_TXN_CURRENCY_CODE_IN
, TP_TXN_CURRENCY_CODE_OUT
, TXN_TRANSFER_PRICE
, PROJECT_CURRENCY_CODE
, PROJECT_COST_RATE_DATE
, PROJECT_COST_RATE_TYPE
, PROJECT_COST_EXCHANGE_RATE
, PROJECT_RAW_COST
, PROJECT_BURDENED_COST
, PROJECT_REVENUE_RATE_DATE
, PROJECT_REVENUE_RATE_TYPE
, PROJECT_REVENUE_EXCHANGE_RATE
, PROJECT_REVENUE
, PROJECT_TP_RATE_DATE
, PROJECT_TP_RATE_TYPE
, PROJECT_TP_EXCHANGE_RATE
, PROJECT_TRANSFER_PRICE
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_EXCHANGE_RATE
, PROJFUNC_RAW_COST
, PROJFUNC_BURDENED_COST
, PROJFUNC_REVENUE_RATE_DATE
, PROJFUNC_REVENUE_RATE_TYPE
, PROJFUNC_REVENUE_EXCHANGE_RATE
, PROJFUNC_REVENUE
, PROJFUNC_TP_RATE_DATE
, PROJFUNC_TP_RATE_TYPE
, PROJFUNC_TP_EXCHANGE_RATE
, PROJFUNC_TRANSFER_PRICE
, EXPFUNC_CURRENCY_CODE
, EXPFUNC_COST_RATE_DATE
, EXPFUNC_COST_RATE_TYPE
, EXPFUNC_COST_EXCHANGE_RATE
, EXPFUNC_RAW_COST
, EXPFUNC_BURDENED_COST
, EXPFUNC_TP_RATE_DATE
, EXPFUNC_TP_RATE_TYPE
, EXPFUNC_TP_EXCHANGE_RATE
, EXPFUNC_TRANSFER_PRICE
, CC_PRVDR_ORG_ID
, CC_PRVDR_ORGANIZITION_ID
, CC_RECVR_ORG_ID
, CC_RECVR_ORGANIZITION_ID
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE
, EXPENDITURE_TYPE_CLASS
, EXPENDITURE_CATEGORY
, TP_LABOR_NL_FLAG
, TP_TASK_ID
, TP_SCHEDULE_ID
, TP_REV_DISTRIBUTED_FLAG
, TP_COMPUTE_FLAG
, TP_FIXED_DATE
, PROJECT_ID
, PERSON_ID
, FORECAST_JOB_ID
, TP_NL_RESOURCE
, TP_NL_RESOURCE_ORGZ_ID
, TP_PA_DATE
, TP_AMOUNT_TYPE
, ASSIGNMENT_ID
, FI_PROCESS_FLAG
, DELETE_FLAG
, TP_ERROR_CODE
, COST_REJECTION_CODE
, REV_REJECTION_CODE
, BURDEN_REJECTION_CODE
, OTHER_REJECTION_CODE
, TP_DENOM_RAW_COST
, TP_DENOM_BURDENED_COST
, TP_RAW_REVENUE
, TP_IND_COMPILED_SETID
, TP_BILL_RATE
, TP_BASE_AMOUNT
, TP_BILL_MARKUP_PERCENT
, TP_SCH_LINE_PERCENT
, TP_RULE_PERCENT
, TP_JOB_ID
, CC_MARKUP_BASECODE
FROM PA.PA_FI_AMOUNT_DTLS_TMP;
PA.PA_FI_AMOUNT_DTLS_TMP does not reference any database object
PA.PA_FI_AMOUNT_DTLS_TMP is referenced by following:
|
|
|