[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_DNGL_FIN |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_FM_DNGL_FIN |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 0 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKER_ID | NUMBER | (15) | Summarization state data | |
DANGLING_RECVR_GL_RATE_FLAG | VARCHAR2 | (1) | Indicates whether primary global currency rate is available on the GL transaction date | |
DANGLING_RECVR_PA_RATE_FLAG | VARCHAR2 | (1) | Indicates whether primary global currency rate is available on the PA transaction date | |
DANGLING_PRVDR_EN_TIME_FLAG | VARCHAR2 | (1) | Indicates whether the resource GL date is outside the enterprise calendar date range | |
DANGLING_RECVR_EN_TIME_FLAG | VARCHAR2 | (1) | Indicates whether the project GL date is outside the enterprise calendar date range | |
DANGLING_RECVR_GL_TIME_FLAG | VARCHAR2 | (1) | Indicates whether the project GL date is outside the GL calendar date range | |
DANGLING_PRVDR_PA_TIME_FLAG | VARCHAR2 | (1) | Indicates whether the resource PA date is outside the PA calendar date range | |
DANGLING_RECVR_PA_TIME_FLAG | VARCHAR2 | (1) | Indicates whether the project PA date is outside the PA calendar date range | |
ROW_ID | ROWID | (10) | ||
PJI_PROJECT_RECORD_FLAG | VARCHAR2 | (1) | Indicates whether the row will go to PJI FM | |
PJI_RESOURCE_RECORD_FLAG | VARCHAR2 | (1) | Indicates whether the row will go to PJI RM | |
PROJECT_ID | NUMBER | (15) | Identifier of the Project | |
PROJECT_ORG_ID | NUMBER | (15) | Identifier of the Project Operating Unit | |
PROJECT_ORGANIZATION_ID | NUMBER | (15) | Identifier of the Project Organization | |
PERSON_ID | NUMBER | (15) | Identifier of the Person | |
EXPENDITURE_ORG_ID | NUMBER | (15) | Identifier of the Expenditure Operating Unit | |
EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Identifier of the Expenditure Organization | |
WORK_TYPE_ID | NUMBER | (15) | Identifier of the Work Type | |
JOB_ID | NUMBER | (15) | Identifier of the Job | |
PRVDR_GL_TIME_ID | NUMBER | (15) | Resource GL transaction date | |
RECVR_GL_TIME_ID | NUMBER | (15) | Project GL transaction date | |
PRVDR_PA_TIME_ID | NUMBER | (15) | Resource PA transaction date | |
RECVR_PA_TIME_ID | NUMBER | (15) | Project PA transaction date | |
PRJ_REVENUE | NUMBER | Revenue by project currency | ||
PRJ_LABOR_REVENUE | NUMBER | Labor Revenue by project currency | ||
PRJ_RAW_COST | NUMBER | Raw Cost by project currency | ||
PRJ_BRDN_COST | NUMBER | Burdened Cost by project currency | ||
PRJ_BILL_RAW_COST | NUMBER | Billable Raw Cost by project currency | ||
PRJ_BILL_BRDN_COST | NUMBER | Billable Burdened Cost by project currency | ||
PRJ_LABOR_RAW_COST | NUMBER | Labor Raw Cost by project currency | ||
PRJ_LABOR_BRDN_COST | NUMBER | Labor Burdened Cost by project currency | ||
PRJ_BILL_LABOR_RAW_COST | NUMBER | Billable Labor Raw Cost by project currency | ||
PRJ_BILL_LABOR_BRDN_COST | NUMBER | Billable Labor Burdened Cost by project currency | ||
PRJ_REVENUE_WRITEOFF | NUMBER | Revenue Write Off by project currency | ||
POU_REVENUE | NUMBER | Revenue by project functional currency | ||
POU_LABOR_REVENUE | NUMBER | Labor Revenue by project functional currency | ||
POU_RAW_COST | NUMBER | Raw Cost by project functional currency | ||
POU_BRDN_COST | NUMBER | Burdened Cost by project functional currency | ||
POU_BILL_RAW_COST | NUMBER | Billable Raw Cost by project functional currency | ||
POU_BILL_BRDN_COST | NUMBER | Billable Burdened Cost by project functional currency | ||
POU_LABOR_RAW_COST | NUMBER | Labor Raw Cost by project functional currency | ||
POU_LABOR_BRDN_COST | NUMBER | Labor Burdened Cost by project functional currency | ||
POU_BILL_LABOR_RAW_COST | NUMBER | Billable Labor Raw Cost by project functional currency | ||
POU_BILL_LABOR_BRDN_COST | NUMBER | Billable Labor Burdened Cost by project functional currency | ||
POU_REVENUE_WRITEOFF | NUMBER | Revenue Write Off by project functional currency | ||
LABOR_HRS | NUMBER | Labor Hours | ||
BILL_LABOR_HRS | NUMBER | Billable Labor Hours | ||
GG_REVENUE | NUMBER | |||
GG_LABOR_REVENUE | NUMBER | |||
GG_RAW_COST | NUMBER | |||
GG_BRDN_COST | NUMBER | |||
GG_BILL_RAW_COST | NUMBER | |||
GG_BILL_BRDN_COST | NUMBER | |||
GG_LABOR_RAW_COST | NUMBER | |||
GG_LABOR_BRDN_COST | NUMBER | |||
GG_BILL_LABOR_RAW_COST | NUMBER | |||
GG_BILL_LABOR_BRDN_COST | NUMBER | |||
GG_REVENUE_WRITEOFF | NUMBER | |||
GP_REVENUE | NUMBER | |||
GP_LABOR_REVENUE | NUMBER | |||
GP_RAW_COST | NUMBER | |||
GP_BRDN_COST | NUMBER | |||
GP_BILL_RAW_COST | NUMBER | |||
GP_BILL_BRDN_COST | NUMBER | |||
GP_LABOR_RAW_COST | NUMBER | |||
GP_LABOR_BRDN_COST | NUMBER | |||
GP_BILL_LABOR_RAW_COST | NUMBER | |||
GP_BILL_LABOR_BRDN_COST | NUMBER | |||
GP_REVENUE_WRITEOFF | NUMBER | |||
TOTAL_HRS_A | NUMBER | Actual Hours | ||
BILL_HRS_A | NUMBER | Billable Actual Hours | ||
EXPENDITURE_ITEM_TIME_ID | NUMBER | (15) | Resource Expenditure Item transaction date | |
DANGLING_PRVDR_GL_TIME_FLAG | VARCHAR2 | (1) | Indicates whether the resource GL date is outside the GL calendar date range | |
DANGLING_EXP_EN_TIME_FLAG | VARCHAR2 | (1) | Indicates whether the resource expenditure item date is outside the enterprise calendar date range | |
DANGLING_EXP_GL_TIME_FLAG | VARCHAR2 | (1) | Indicates whether the resource expenditure item date is outside the GL calendar date range | |
DANGLING_EXP_PA_TIME_FLAG | VARCHAR2 | (1) | Indicates whether the resource expenditure item date is outside the PA calendar date range | |
EXP_EVT_TYPE_ID | NUMBER | (15) | Identifier of the Expenditure / Event Type | |
PROJECT_TYPE_CLASS | VARCHAR2 | (1) | Identifier of the Project Type Class | |
PJ_GL_CALENDAR_ID | NUMBER | (15) | Project Operating Unit GL calendar | |
PJ_PA_CALENDAR_ID | NUMBER | (15) | Project Operating Unit PA calendar | |
RS_GL_CALENDAR_ID | NUMBER | (15) | Expenditure Operating Unit GL calendar | |
RS_PA_CALENDAR_ID | NUMBER | (15) | Expenditure Operating Unit PA calendar | |
RECORD_TYPE | VARCHAR2 | (1) | Data extraction type M = Commitments; A = Actuals | |
CMT_RECORD_TYPE | VARCHAR2 | (1) | Commitments record type I = Invoices; P = Purchase orders; R = Requisition orders; O = Others | |
DANGLING_RECVR_GL_RATE2_FLAG | VARCHAR2 | (1) | Indicates whether secondary global currency rate is available on the GL transaction date | |
DANGLING_RECVR_PA_RATE2_FLAG | VARCHAR2 | (1) | Indicates whether secondary global currency rate is available on the PA transaction date | |
TASK_ID | NUMBER | (15) | Identifier of the Task | |
VENDOR_ID | NUMBER | (15) | Identifier of the Vendor | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Identifier of the Expenditure Type | |
EVENT_TYPE | VARCHAR2 | (30) | Identifier of the Event Type | |
EVENT_TYPE_CLASSIFICATION | VARCHAR2 | (30) | Identifier of the Event Type Classification | |
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | Identifier of the Expenditure Category | |
REVENUE_CATEGORY | VARCHAR2 | (30) | Identifier of the Revenue Category | |
NON_LABOR_RESOURCE | VARCHAR2 | (30) | Identifier of the Non Labor Resource | |
BOM_LABOR_RESOURCE_ID | NUMBER | (15) | Identifier of the Bill of Materials Labor Resource | |
BOM_EQUIPMENT_RESOURCE_ID | NUMBER | (15) | Identifier of the Bill of Materials Equipment Resource | |
INVENTORY_ITEM_ID | NUMBER | (15) | Identifier of the Inventory Item | |
SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | (30) | System Linkage lookup | |
GL_PERIOD_NAME | VARCHAR2 | (15) | GL Period Name | |
PA_PERIOD_NAME | VARCHAR2 | (15) | PA Period Name | |
TXN_CURRENCY_CODE | VARCHAR2 | (30) | Transaction Currency | |
TXN_REVENUE | NUMBER | Revenue by transaction currency | ||
TXN_RAW_COST | NUMBER | Raw Cost by transaction currency | ||
TXN_BRDN_COST | NUMBER | Burdened Cost by transaction currency | ||
TXN_BILL_RAW_COST | NUMBER | Billable Raw Cost by transaction currency | ||
TXN_BILL_BRDN_COST | NUMBER | Billable Burdened by transaction currency | ||
TXN_UBR | NUMBER | Unbilled Receivables by transaction currency | ||
TXN_UER | NUMBER | Unearned Revenue by transaction currency | ||
POU_UBR | NUMBER | Unbilled Receivables by project functional currency | ||
POU_UER | NUMBER | Unearned Revenue by project functional currency | ||
EOU_REVENUE | NUMBER | Revenue by expenditure functional currency | ||
EOU_RAW_COST | NUMBER | Raw Cost by expenditure functional currency | ||
EOU_BRDN_COST | NUMBER | Burdened Cost by expenditure functional currency | ||
EOU_BILL_RAW_COST | NUMBER | Billable Raw Cost by expenditure functional currency | ||
EOU_BILL_BRDN_COST | NUMBER | Billable Burdened Cost by expenditure functional currency | ||
EOU_UBR | NUMBER | Unbilled Receivables by expenditure functional currency | ||
EOU_UER | NUMBER | Unearned Revenue by expenditure functional currency | ||
GG1_REVENUE | NUMBER | Revenue converted to primary global currency on GL transaction date | ||
GG1_LABOR_REVENUE | NUMBER | Labor Revenue converted to primary global currency on GL transaction date | ||
GG1_RAW_COST | NUMBER | Raw Cost converted to primary global currency on GL transaction date | ||
GG1_BRDN_COST | NUMBER | Burdened Cost converted to primary global currency on GL transaction date | ||
GG1_BILL_RAW_COST | NUMBER | Billable Raw Cost converted to primary global currency on GL transaction date | ||
GG1_BILL_BRDN_COST | NUMBER | Billable Burdened Cost converted to primary global currency on GL transaction date | ||
GG1_LABOR_RAW_COST | NUMBER | Labor Raw Cost converted to primary global currency on GL transaction date | ||
GG1_LABOR_BRDN_COST | NUMBER | Labor Burdened Cost converted to primary global currency on GL transaction date | ||
GG1_BILL_LABOR_RAW_COST | NUMBER | Billable Labor Raw Cost converted to primary global currency on GL transaction date | ||
GG1_BILL_LABOR_BRDN_COST | NUMBER | Billable Labor Burdened Cost converted to primary global currency on GL transaction date | ||
GG1_REVENUE_WRITEOFF | NUMBER | Revenue Writeoff converted to primary global currency on GL transaction date | ||
GG1_UBR | NUMBER | Unbilled Receivables converted to primary global currency on GL transaction date | ||
GG1_UER | NUMBER | Unearned Revenue converted to primary global currency on GL transaction date | ||
GP1_REVENUE | NUMBER | Revenue converted to primary global currency on PA transaction date | ||
GP1_LABOR_REVENUE | NUMBER | Labor Revenue converted to primary global currency on PA transaction date | ||
GP1_RAW_COST | NUMBER | Raw Cost converted to primary global currency on PA transaction date | ||
GP1_BRDN_COST | NUMBER | Burdened Cost converted to primary global currency on PA transaction date | ||
GP1_BILL_RAW_COST | NUMBER | Billable Raw Cost converted to primary global currency on PA transaction date | ||
GP1_BILL_BRDN_COST | NUMBER | Billable Burdened Cost converted to primary global currency on PA transaction date | ||
GP1_LABOR_RAW_COST | NUMBER | Labor Raw Cost converted to primary global currency on PA transaction date | ||
GP1_LABOR_BRDN_COST | NUMBER | Labor Burdened Cost converted to primary global currency on PA transaction date | ||
GP1_BILL_LABOR_RAW_COST | NUMBER | Billable Labor Raw Cost converted to primary global currency on PA transaction date | ||
GP1_BILL_LABOR_BRDN_COST | NUMBER | Billable Labor Burdened Cost converted to primary global currency on PA transaction date | ||
GP1_REVENUE_WRITEOFF | NUMBER | Revenue Writeoff converted to primary global currency on PA transaction date | ||
GP1_UBR | NUMBER | Unbilled Receivables converted to primary global currency on PA transaction date | ||
GP1_UER | NUMBER | Unearned Revenue converted to primary global currency on PA transaction date | ||
GG2_REVENUE | NUMBER | Revenue converted to secondary global currency on GL transaction date | ||
GG2_LABOR_REVENUE | NUMBER | Labor Revenue converted to secondary global currency on GL transaction date | ||
GG2_RAW_COST | NUMBER | Raw Cost converted to secondary global currency on GL transaction date | ||
GG2_BRDN_COST | NUMBER | Burdened Cost converted to secondary global currency on GL transaction date | ||
GG2_BILL_RAW_COST | NUMBER | Billable Raw Cost converted to secondary global currency on GL transaction date | ||
GG2_BILL_BRDN_COST | NUMBER | Billable Burdened Cost converted to secondary global currency on GL transaction date | ||
GG2_LABOR_RAW_COST | NUMBER | Labor Raw Cost converted to secondary global currency on GL transaction date | ||
GG2_LABOR_BRDN_COST | NUMBER | Labor Burdened Cost converted to secondary global currency on GL transaction date | ||
GG2_BILL_LABOR_RAW_COST | NUMBER | Billable Labor Raw Cost converted to secondary global currency on GL transaction date | ||
GG2_BILL_LABOR_BRDN_COST | NUMBER | Billable Labor Burdened Cost converted to secondary global currency on GL transaction date | ||
GG2_REVENUE_WRITEOFF | NUMBER | Revenue Writeoff converted to secondary global currency on GL transaction date | ||
GG2_UBR | NUMBER | Unbilled Receivables converted to secondary global currency on GL transaction date | ||
GG2_UER | NUMBER | Unearned Revenue converted to secondary global currency on GL transaction date | ||
GP2_REVENUE | NUMBER | Revenue converted to secondary global currency on PA transaction date | ||
GP2_LABOR_REVENUE | NUMBER | Labor Revenue converted to secondary global currency on PA transaction date | ||
GP2_RAW_COST | NUMBER | Raw Cost converted to secondary global currency on PA transaction date | ||
GP2_BRDN_COST | NUMBER | Burdened Cost converted to secondary global currency on PA transaction date | ||
GP2_BILL_RAW_COST | NUMBER | Billable Raw Cost converted to secondary global currency on PA transaction date | ||
GP2_BILL_BRDN_COST | NUMBER | Billable Burdened Cost converted to secondary global currency on PA transaction date | ||
GP2_LABOR_RAW_COST | NUMBER | Labor Raw Cost converted to secondary global currency on PA transaction date | ||
GP2_LABOR_BRDN_COST | NUMBER | Labor Burdened Cost converted to secondary global currency on PA transaction date | ||
GP2_BILL_LABOR_RAW_COST | NUMBER | Billable Labor Raw Cost converted to secondary global currency on PA transaction date | ||
GP2_BILL_LABOR_BRDN_COST | NUMBER | Billable Labor Burdened Cost converted to secondary global currency on PA transaction date | ||
GP2_REVENUE_WRITEOFF | NUMBER | Revenue Writeoff converted to secondary global currency on PA transaction date | ||
GP2_UBR | NUMBER | Unbilled Receivables converted to secondary global currency on PA transaction date | ||
GP2_UER | NUMBER | Unearned Revenue converted to secondary global currency on PA transaction date | ||
PO_LINE_ID | NUMBER | |||
RESOURCE_CLASS_CODE | VARCHAR2 | (30) | ||
ASSIGNMENT_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT WORKER_ID
, DANGLING_RECVR_GL_RATE_FLAG
, DANGLING_RECVR_PA_RATE_FLAG
, DANGLING_PRVDR_EN_TIME_FLAG
, DANGLING_RECVR_EN_TIME_FLAG
, DANGLING_RECVR_GL_TIME_FLAG
, DANGLING_PRVDR_PA_TIME_FLAG
, DANGLING_RECVR_PA_TIME_FLAG
, ROW_ID
, PJI_PROJECT_RECORD_FLAG
, PJI_RESOURCE_RECORD_FLAG
, PROJECT_ID
, PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID
, PERSON_ID
, EXPENDITURE_ORG_ID
, EXPENDITURE_ORGANIZATION_ID
, WORK_TYPE_ID
, JOB_ID
, PRVDR_GL_TIME_ID
, RECVR_GL_TIME_ID
, PRVDR_PA_TIME_ID
, RECVR_PA_TIME_ID
, PRJ_REVENUE
, PRJ_LABOR_REVENUE
, PRJ_RAW_COST
, PRJ_BRDN_COST
, PRJ_BILL_RAW_COST
, PRJ_BILL_BRDN_COST
, PRJ_LABOR_RAW_COST
, PRJ_LABOR_BRDN_COST
, PRJ_BILL_LABOR_RAW_COST
, PRJ_BILL_LABOR_BRDN_COST
, PRJ_REVENUE_WRITEOFF
, POU_REVENUE
, POU_LABOR_REVENUE
, POU_RAW_COST
, POU_BRDN_COST
, POU_BILL_RAW_COST
, POU_BILL_BRDN_COST
, POU_LABOR_RAW_COST
, POU_LABOR_BRDN_COST
, POU_BILL_LABOR_RAW_COST
, POU_BILL_LABOR_BRDN_COST
, POU_REVENUE_WRITEOFF
, LABOR_HRS
, BILL_LABOR_HRS
, GG_REVENUE
, GG_LABOR_REVENUE
, GG_RAW_COST
, GG_BRDN_COST
, GG_BILL_RAW_COST
, GG_BILL_BRDN_COST
, GG_LABOR_RAW_COST
, GG_LABOR_BRDN_COST
, GG_BILL_LABOR_RAW_COST
, GG_BILL_LABOR_BRDN_COST
, GG_REVENUE_WRITEOFF
, GP_REVENUE
, GP_LABOR_REVENUE
, GP_RAW_COST
, GP_BRDN_COST
, GP_BILL_RAW_COST
, GP_BILL_BRDN_COST
, GP_LABOR_RAW_COST
, GP_LABOR_BRDN_COST
, GP_BILL_LABOR_RAW_COST
, GP_BILL_LABOR_BRDN_COST
, GP_REVENUE_WRITEOFF
, TOTAL_HRS_A
, BILL_HRS_A
, EXPENDITURE_ITEM_TIME_ID
, DANGLING_PRVDR_GL_TIME_FLAG
, DANGLING_EXP_EN_TIME_FLAG
, DANGLING_EXP_GL_TIME_FLAG
, DANGLING_EXP_PA_TIME_FLAG
, EXP_EVT_TYPE_ID
, PROJECT_TYPE_CLASS
, PJ_GL_CALENDAR_ID
, PJ_PA_CALENDAR_ID
, RS_GL_CALENDAR_ID
, RS_PA_CALENDAR_ID
, RECORD_TYPE
, CMT_RECORD_TYPE
, DANGLING_RECVR_GL_RATE2_FLAG
, DANGLING_RECVR_PA_RATE2_FLAG
, TASK_ID
, VENDOR_ID
, EXPENDITURE_TYPE
, EVENT_TYPE
, EVENT_TYPE_CLASSIFICATION
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, NON_LABOR_RESOURCE
, BOM_LABOR_RESOURCE_ID
, BOM_EQUIPMENT_RESOURCE_ID
, INVENTORY_ITEM_ID
, SYSTEM_LINKAGE_FUNCTION
, GL_PERIOD_NAME
, PA_PERIOD_NAME
, TXN_CURRENCY_CODE
, TXN_REVENUE
, TXN_RAW_COST
, TXN_BRDN_COST
, TXN_BILL_RAW_COST
, TXN_BILL_BRDN_COST
, TXN_UBR
, TXN_UER
, POU_UBR
, POU_UER
, EOU_REVENUE
, EOU_RAW_COST
, EOU_BRDN_COST
, EOU_BILL_RAW_COST
, EOU_BILL_BRDN_COST
, EOU_UBR
, EOU_UER
, GG1_REVENUE
, GG1_LABOR_REVENUE
, GG1_RAW_COST
, GG1_BRDN_COST
, GG1_BILL_RAW_COST
, GG1_BILL_BRDN_COST
, GG1_LABOR_RAW_COST
, GG1_LABOR_BRDN_COST
, GG1_BILL_LABOR_RAW_COST
, GG1_BILL_LABOR_BRDN_COST
, GG1_REVENUE_WRITEOFF
, GG1_UBR
, GG1_UER
, GP1_REVENUE
, GP1_LABOR_REVENUE
, GP1_RAW_COST
, GP1_BRDN_COST
, GP1_BILL_RAW_COST
, GP1_BILL_BRDN_COST
, GP1_LABOR_RAW_COST
, GP1_LABOR_BRDN_COST
, GP1_BILL_LABOR_RAW_COST
, GP1_BILL_LABOR_BRDN_COST
, GP1_REVENUE_WRITEOFF
, GP1_UBR
, GP1_UER
, GG2_REVENUE
, GG2_LABOR_REVENUE
, GG2_RAW_COST
, GG2_BRDN_COST
, GG2_BILL_RAW_COST
, GG2_BILL_BRDN_COST
, GG2_LABOR_RAW_COST
, GG2_LABOR_BRDN_COST
, GG2_BILL_LABOR_RAW_COST
, GG2_BILL_LABOR_BRDN_COST
, GG2_REVENUE_WRITEOFF
, GG2_UBR
, GG2_UER
, GP2_REVENUE
, GP2_LABOR_REVENUE
, GP2_RAW_COST
, GP2_BRDN_COST
, GP2_BILL_RAW_COST
, GP2_BILL_BRDN_COST
, GP2_LABOR_RAW_COST
, GP2_LABOR_BRDN_COST
, GP2_BILL_LABOR_RAW_COST
, GP2_BILL_LABOR_BRDN_COST
, GP2_REVENUE_WRITEOFF
, GP2_UBR
, GP2_UER
, PO_LINE_ID
, RESOURCE_CLASS_CODE
, ASSIGNMENT_ID
FROM PJI.PJI_FM_DNGL_FIN;
PJI.PJI_FM_DNGL_FIN does not reference any database object
PJI.PJI_FM_DNGL_FIN is referenced by following:
|
|
|