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

TABLE: PA.PA_COST_DIST_LINES_AR

Object Details
Object Name: PA_COST_DIST_LINES_AR
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_COST_DIST_LINES_AR
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_COST_DIST_LINES_AR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPURGE_PROJECT_ID
Columns
Name Datatype Length Mandatory Comments
PURGE_BATCH_ID NUMBER (15) Yes
PURGE_RELEASE VARCHAR2 (50) Yes
PURGE_PROJECT_ID NUMBER (15) Yes
FUNCTION_TRANSACTION_CODE VARCHAR2 (30)
ORG_ID NUMBER (15)
CODE_COMBINATION_ID NUMBER (15)
EXPENDITURE_ITEM_ID NUMBER (15)
LINE_NUM NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
TRANSFER_STATUS_CODE VARCHAR2 (1)
AMOUNT NUMBER (22)
QUANTITY NUMBER (22)
BILLABLE_FLAG VARCHAR2 (1)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

PA_DATE DATE

DR_CODE_COMBINATION_ID NUMBER (15)
GL_DATE DATE

TRANSFERRED_DATE DATE

TRANSFER_REJECTION_REASON VARCHAR2 (250)
BATCH_NAME VARCHAR2 (30)
ACCUMULATED_FLAG VARCHAR2 (1)
REVERSED_FLAG VARCHAR2 (1)
LINE_NUM_REVERSED NUMBER (15)
SYSTEM_REFERENCE1 VARCHAR2 (30)
SYSTEM_REFERENCE2 VARCHAR2 (30)
SYSTEM_REFERENCE3 VARCHAR2 (30)
CR_CODE_COMBINATION_ID NUMBER (15)
IND_COMPILED_SET_ID NUMBER (15)
LINE_TYPE VARCHAR2 (1)
BURDENED_COST NUMBER (22)
RESOURCE_ACCUMULATED_FLAG VARCHAR2 (1)
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

ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_RATE_DATE DATE

PROJECT_RATE_TYPE VARCHAR2 (30)
PROJECT_EXCHANGE_RATE NUMBER

TASK_ID NUMBER (15)
PRC_GENERATED_FLAG VARCHAR2 (1)
BUDGET_CCID NUMBER (15)
RECVR_PA_DATE DATE

ENCUMBRANCE_AMOUNT NUMBER

BURDEN_SUM_SOURCE_RUN_ID NUMBER (15)
PROJFUNC_COST_EXCHANGE_RATE NUMBER

RECVR_GL_DATE DATE

ENCUMBRANCE_TYPE_ID NUMBER (15)
PA_PERIOD_NAME VARCHAR2 (15)
ENCUM_TRANSFER_REJ_REASON VARCHAR2 (250)
PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
PROJECT_RAW_COST NUMBER

BURDEN_SUM_REJECTION_CODE VARCHAR2 (30)
PROJFUNC_COST_RATE_DATE DATE

UTIL_SUMMARIZED_FLAG VARCHAR2 (1)
RECVR_PA_PERIOD_NAME VARCHAR2 (15)
PROJECT_BURDENED_COST NUMBER

PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
LIQUIDATE_ENCUM_FLAG VARCHAR2 (1)
PROJECT_ID NUMBER (15)
SYSTEM_REFERENCE4 VARCHAR2 (30)
PJI_SUMMARIZED_FLAG VARCHAR2 (1)
WORK_TYPE_ID NUMBER (15)
ENCUMBRANCE_BATCH_NAME VARCHAR2 (240)
GL_PERIOD_NAME VARCHAR2 (15)
RECVR_GL_PERIOD_NAME VARCHAR2 (15)
ORG_LABOR_SCH_RULE_ID NUMBER (15)
Identifier for org schedule assignment
COST_RATE_SCH_ID NUMBER (15)
The identifier of the cost rate schedule used during costing.
DENOM_BURDENED_CHANGE NUMBER

PROJECT_BURDENED_CHANGE NUMBER

PROJFUNC_BURDENED_CHANGE NUMBER

ACCT_BURDENED_CHANGE NUMBER

PARENT_LINE_NUM NUMBER (15)
PREV_IND_COMPILED_SET_ID NUMBER (15)
SI_ASSETS_ADDITION_FLAG VARCHAR2 (1)
SYSTEM_REFERENCE5 NUMBER (15)
ACCT_EVENT_ID NUMBER (15)
ACCT_SOURCE_CODE VARCHAR2 (10)
CBS_ELEMENT_ID NUMBER (15)
Unique id corresponding to the cost code.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PURGE_BATCH_ID
,      PURGE_RELEASE
,      PURGE_PROJECT_ID
,      FUNCTION_TRANSACTION_CODE
,      ORG_ID
,      CODE_COMBINATION_ID
,      EXPENDITURE_ITEM_ID
,      LINE_NUM
,      CREATION_DATE
,      CREATED_BY
,      TRANSFER_STATUS_CODE
,      AMOUNT
,      QUANTITY
,      BILLABLE_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PA_DATE
,      DR_CODE_COMBINATION_ID
,      GL_DATE
,      TRANSFERRED_DATE
,      TRANSFER_REJECTION_REASON
,      BATCH_NAME
,      ACCUMULATED_FLAG
,      REVERSED_FLAG
,      LINE_NUM_REVERSED
,      SYSTEM_REFERENCE1
,      SYSTEM_REFERENCE2
,      SYSTEM_REFERENCE3
,      CR_CODE_COMBINATION_ID
,      IND_COMPILED_SET_ID
,      LINE_TYPE
,      BURDENED_COST
,      RESOURCE_ACCUMULATED_FLAG
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      TASK_ID
,      PRC_GENERATED_FLAG
,      BUDGET_CCID
,      RECVR_PA_DATE
,      ENCUMBRANCE_AMOUNT
,      BURDEN_SUM_SOURCE_RUN_ID
,      PROJFUNC_COST_EXCHANGE_RATE
,      RECVR_GL_DATE
,      ENCUMBRANCE_TYPE_ID
,      PA_PERIOD_NAME
,      ENCUM_TRANSFER_REJ_REASON
,      PROJFUNC_COST_RATE_TYPE
,      PROJECT_RAW_COST
,      BURDEN_SUM_REJECTION_CODE
,      PROJFUNC_COST_RATE_DATE
,      UTIL_SUMMARIZED_FLAG
,      RECVR_PA_PERIOD_NAME
,      PROJECT_BURDENED_COST
,      PROJFUNC_CURRENCY_CODE
,      LIQUIDATE_ENCUM_FLAG
,      PROJECT_ID
,      SYSTEM_REFERENCE4
,      PJI_SUMMARIZED_FLAG
,      WORK_TYPE_ID
,      ENCUMBRANCE_BATCH_NAME
,      GL_PERIOD_NAME
,      RECVR_GL_PERIOD_NAME
,      ORG_LABOR_SCH_RULE_ID
,      COST_RATE_SCH_ID
,      DENOM_BURDENED_CHANGE
,      PROJECT_BURDENED_CHANGE
,      PROJFUNC_BURDENED_CHANGE
,      ACCT_BURDENED_CHANGE
,      PARENT_LINE_NUM
,      PREV_IND_COMPILED_SET_ID
,      SI_ASSETS_ADDITION_FLAG
,      SYSTEM_REFERENCE5
,      ACCT_EVENT_ID
,      ACCT_SOURCE_CODE
,      CBS_ELEMENT_ID
FROM PA.PA_COST_DIST_LINES_AR;

Dependencies

[top of page]

PA.PA_COST_DIST_LINES_AR does not reference any database object

PA.PA_COST_DIST_LINES_AR is referenced by following:

SchemaPA
ViewPA_COST_DIST_LINES_AR#