Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_FI_AMOUNT_DTLS_TMP

Object Details
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.

Temporary Table Details

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.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
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)
Query Text

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;

Dependencies

[top of page]

PA.PA_FI_AMOUNT_DTLS_TMP does not reference any database object

PA.PA_FI_AMOUNT_DTLS_TMP is referenced by following:

SchemaAPPS
SynonymPA_FI_AMOUNT_DTLS_TMP