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

VIEW: PJI.PJI_FM_AGGR_ACT2#

Object Details
Object Name: PJI_FM_AGGR_ACT2#
Object Type: VIEW
Owner: PJI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER

DANGLING_GL_RATE_FLAG VARCHAR2 (1)
DANGLING_PA_RATE_FLAG VARCHAR2 (1)
DANGLING_EN_TIME_FLAG VARCHAR2 (1)
DANGLING_GL_TIME_FLAG VARCHAR2 (1)
DANGLING_PA_TIME_FLAG VARCHAR2 (1)
ROW_ID ROWID (10)
PROJECT_ID NUMBER

PROJECT_ORG_ID NUMBER

PROJECT_ORGANIZATION_ID NUMBER

GL_TIME_ID NUMBER

PA_TIME_ID NUMBER

PRJ_REVENUE NUMBER

PRJ_FUNDING NUMBER

PRJ_INITIAL_FUNDING_AMOUNT NUMBER

PRJ_ADDITIONAL_FUNDING_AMOUNT NUMBER

PRJ_CANCELLED_FUNDING_AMOUNT NUMBER

PRJ_FUNDING_ADJUSTMENT_AMOUNT NUMBER

PRJ_REVENUE_WRITEOFF NUMBER

PRJ_AR_INVOICE_AMOUNT NUMBER

PRJ_AR_CASH_APPLIED_AMOUNT NUMBER

PRJ_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

PRJ_AR_CREDIT_MEMO_AMOUNT NUMBER

PRJ_UNBILLED_RECEIVABLES NUMBER

PRJ_UNEARNED_REVENUE NUMBER

PRJ_AR_UNAPPR_INVOICE_AMOUNT NUMBER

PRJ_AR_APPR_INVOICE_AMOUNT NUMBER

PRJ_AR_AMOUNT_DUE NUMBER

PRJ_AR_AMOUNT_OVERDUE NUMBER

POU_REVENUE NUMBER

POU_FUNDING NUMBER

POU_INITIAL_FUNDING_AMOUNT NUMBER

POU_ADDITIONAL_FUNDING_AMOUNT NUMBER

POU_CANCELLED_FUNDING_AMOUNT NUMBER

POU_FUNDING_ADJUSTMENT_AMOUNT NUMBER

POU_REVENUE_WRITEOFF NUMBER

POU_AR_INVOICE_AMOUNT NUMBER

POU_AR_CASH_APPLIED_AMOUNT NUMBER

POU_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

POU_AR_CREDIT_MEMO_AMOUNT NUMBER

POU_UNBILLED_RECEIVABLES NUMBER

POU_UNEARNED_REVENUE NUMBER

POU_AR_UNAPPR_INVOICE_AMOUNT NUMBER

POU_AR_APPR_INVOICE_AMOUNT NUMBER

POU_AR_AMOUNT_DUE NUMBER

POU_AR_AMOUNT_OVERDUE NUMBER

INITIAL_FUNDING_COUNT NUMBER

ADDITIONAL_FUNDING_COUNT NUMBER

CANCELLED_FUNDING_COUNT NUMBER

FUNDING_ADJUSTMENT_COUNT NUMBER

AR_INVOICE_COUNT NUMBER

AR_CASH_APPLIED_COUNT NUMBER

AR_INVOICE_WRITEOFF_COUNT NUMBER

AR_CREDIT_MEMO_COUNT NUMBER

AR_UNAPPR_INVOICE_COUNT NUMBER

AR_APPR_INVOICE_COUNT NUMBER

AR_COUNT_DUE NUMBER

AR_COUNT_OVERDUE NUMBER

GG_REVENUE NUMBER

GG_FUNDING NUMBER

GG_INITIAL_FUNDING_AMOUNT NUMBER

GG_ADDITIONAL_FUNDING_AMOUNT NUMBER

GG_CANCELLED_FUNDING_AMOUNT NUMBER

GG_FUNDING_ADJUSTMENT_AMOUNT NUMBER

GG_REVENUE_WRITEOFF NUMBER

GG_AR_INVOICE_AMOUNT NUMBER

GG_AR_CASH_APPLIED_AMOUNT NUMBER

GG_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

GG_AR_CREDIT_MEMO_AMOUNT NUMBER

GG_UNBILLED_RECEIVABLES NUMBER

GG_UNEARNED_REVENUE NUMBER

GG_AR_UNAPPR_INVOICE_AMOUNT NUMBER

GG_AR_APPR_INVOICE_AMOUNT NUMBER

GG_AR_AMOUNT_DUE NUMBER

GG_AR_AMOUNT_OVERDUE NUMBER

GP_REVENUE NUMBER

GP_FUNDING NUMBER

GP_INITIAL_FUNDING_AMOUNT NUMBER

GP_ADDITIONAL_FUNDING_AMOUNT NUMBER

GP_CANCELLED_FUNDING_AMOUNT NUMBER

GP_FUNDING_ADJUSTMENT_AMOUNT NUMBER

GP_REVENUE_WRITEOFF NUMBER

GP_AR_INVOICE_AMOUNT NUMBER

GP_AR_CASH_APPLIED_AMOUNT NUMBER

GP_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

GP_AR_CREDIT_MEMO_AMOUNT NUMBER

GP_UNBILLED_RECEIVABLES NUMBER

GP_UNEARNED_REVENUE NUMBER

GP_AR_UNAPPR_INVOICE_AMOUNT NUMBER

GP_AR_APPR_INVOICE_AMOUNT NUMBER

GP_AR_AMOUNT_DUE NUMBER

GP_AR_AMOUNT_OVERDUE NUMBER

GL_CALENDAR_ID NUMBER

PA_CALENDAR_ID NUMBER

DANGLING_GL_RATE2_FLAG VARCHAR2 (1)
DANGLING_PA_RATE2_FLAG VARCHAR2 (1)
TASK_ID NUMBER

GL_PERIOD_NAME VARCHAR2 (15)
PA_PERIOD_NAME VARCHAR2 (15)
TXN_CURRENCY_CODE VARCHAR2 (30)
TXN_REVENUE NUMBER

TXN_FUNDING NUMBER

TXN_INITIAL_FUNDING_AMOUNT NUMBER

TXN_ADDITIONAL_FUNDING_AMOUNT NUMBER

TXN_CANCELLED_FUNDING_AMOUNT NUMBER

TXN_FUNDING_ADJUSTMENT_AMOUNT NUMBER

TXN_REVENUE_WRITEOFF NUMBER

TXN_AR_INVOICE_AMOUNT NUMBER

TXN_AR_CASH_APPLIED_AMOUNT NUMBER

TXN_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

TXN_AR_CREDIT_MEMO_AMOUNT NUMBER

TXN_UNBILLED_RECEIVABLES NUMBER

TXN_UNEARNED_REVENUE NUMBER

TXN_AR_UNAPPR_INVOICE_AMOUNT NUMBER

TXN_AR_APPR_INVOICE_AMOUNT NUMBER

TXN_AR_AMOUNT_DUE NUMBER

TXN_AR_AMOUNT_OVERDUE NUMBER

GG2_REVENUE NUMBER

GG2_FUNDING NUMBER

GG2_INITIAL_FUNDING_AMOUNT NUMBER

GG2_ADDITIONAL_FUNDING_AMOUNT NUMBER

GG2_CANCELLED_FUNDING_AMOUNT NUMBER

GG2_FUNDING_ADJUSTMENT_AMOUNT NUMBER

GG2_REVENUE_WRITEOFF NUMBER

GG2_AR_INVOICE_AMOUNT NUMBER

GG2_AR_CASH_APPLIED_AMOUNT NUMBER

GG2_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

GG2_AR_CREDIT_MEMO_AMOUNT NUMBER

GG2_UNBILLED_RECEIVABLES NUMBER

GG2_UNEARNED_REVENUE NUMBER

GG2_AR_UNAPPR_INVOICE_AMOUNT NUMBER

GG2_AR_APPR_INVOICE_AMOUNT NUMBER

GG2_AR_AMOUNT_DUE NUMBER

GG2_AR_AMOUNT_OVERDUE NUMBER

GP2_REVENUE NUMBER

GP2_FUNDING NUMBER

GP2_INITIAL_FUNDING_AMOUNT NUMBER

GP2_ADDITIONAL_FUNDING_AMOUNT NUMBER

GP2_CANCELLED_FUNDING_AMOUNT NUMBER

GP2_FUNDING_ADJUSTMENT_AMOUNT NUMBER

GP2_REVENUE_WRITEOFF NUMBER

GP2_AR_INVOICE_AMOUNT NUMBER

GP2_AR_CASH_APPLIED_AMOUNT NUMBER

GP2_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

GP2_AR_CREDIT_MEMO_AMOUNT NUMBER

GP2_UNBILLED_RECEIVABLES NUMBER

GP2_UNEARNED_REVENUE NUMBER

GP2_AR_UNAPPR_INVOICE_AMOUNT NUMBER

GP2_AR_APPR_INVOICE_AMOUNT NUMBER

GP2_AR_AMOUNT_DUE NUMBER

GP2_AR_AMOUNT_OVERDUE NUMBER

Query Text

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


SELECT WORKER_ID
,      DANGLING_GL_RATE_FLAG
,      DANGLING_PA_RATE_FLAG
,      DANGLING_EN_TIME_FLAG
,      DANGLING_GL_TIME_FLAG
,      DANGLING_PA_TIME_FLAG
,      ROW_ID
,      PROJECT_ID
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      GL_TIME_ID
,      PA_TIME_ID
,      PRJ_REVENUE
,      PRJ_FUNDING
,      PRJ_INITIAL_FUNDING_AMOUNT
,      PRJ_ADDITIONAL_FUNDING_AMOUNT
,      PRJ_CANCELLED_FUNDING_AMOUNT
,      PRJ_FUNDING_ADJUSTMENT_AMOUNT
,      PRJ_REVENUE_WRITEOFF
,      PRJ_AR_INVOICE_AMOUNT
,      PRJ_AR_CASH_APPLIED_AMOUNT
,      PRJ_AR_INVOICE_WRITEOFF_AMOUNT
,      PRJ_AR_CREDIT_MEMO_AMOUNT
,      PRJ_UNBILLED_RECEIVABLES
,      PRJ_UNEARNED_REVENUE
,      PRJ_AR_UNAPPR_INVOICE_AMOUNT
,      PRJ_AR_APPR_INVOICE_AMOUNT
,      PRJ_AR_AMOUNT_DUE
,      PRJ_AR_AMOUNT_OVERDUE
,      POU_REVENUE
,      POU_FUNDING
,      POU_INITIAL_FUNDING_AMOUNT
,      POU_ADDITIONAL_FUNDING_AMOUNT
,      POU_CANCELLED_FUNDING_AMOUNT
,      POU_FUNDING_ADJUSTMENT_AMOUNT
,      POU_REVENUE_WRITEOFF
,      POU_AR_INVOICE_AMOUNT
,      POU_AR_CASH_APPLIED_AMOUNT
,      POU_AR_INVOICE_WRITEOFF_AMOUNT
,      POU_AR_CREDIT_MEMO_AMOUNT
,      POU_UNBILLED_RECEIVABLES
,      POU_UNEARNED_REVENUE
,      POU_AR_UNAPPR_INVOICE_AMOUNT
,      POU_AR_APPR_INVOICE_AMOUNT
,      POU_AR_AMOUNT_DUE
,      POU_AR_AMOUNT_OVERDUE
,      INITIAL_FUNDING_COUNT
,      ADDITIONAL_FUNDING_COUNT
,      CANCELLED_FUNDING_COUNT
,      FUNDING_ADJUSTMENT_COUNT
,      AR_INVOICE_COUNT
,      AR_CASH_APPLIED_COUNT
,      AR_INVOICE_WRITEOFF_COUNT
,      AR_CREDIT_MEMO_COUNT
,      AR_UNAPPR_INVOICE_COUNT
,      AR_APPR_INVOICE_COUNT
,      AR_COUNT_DUE
,      AR_COUNT_OVERDUE
,      GG_REVENUE
,      GG_FUNDING
,      GG_INITIAL_FUNDING_AMOUNT
,      GG_ADDITIONAL_FUNDING_AMOUNT
,      GG_CANCELLED_FUNDING_AMOUNT
,      GG_FUNDING_ADJUSTMENT_AMOUNT
,      GG_REVENUE_WRITEOFF
,      GG_AR_INVOICE_AMOUNT
,      GG_AR_CASH_APPLIED_AMOUNT
,      GG_AR_INVOICE_WRITEOFF_AMOUNT
,      GG_AR_CREDIT_MEMO_AMOUNT
,      GG_UNBILLED_RECEIVABLES
,      GG_UNEARNED_REVENUE
,      GG_AR_UNAPPR_INVOICE_AMOUNT
,      GG_AR_APPR_INVOICE_AMOUNT
,      GG_AR_AMOUNT_DUE
,      GG_AR_AMOUNT_OVERDUE
,      GP_REVENUE
,      GP_FUNDING
,      GP_INITIAL_FUNDING_AMOUNT
,      GP_ADDITIONAL_FUNDING_AMOUNT
,      GP_CANCELLED_FUNDING_AMOUNT
,      GP_FUNDING_ADJUSTMENT_AMOUNT
,      GP_REVENUE_WRITEOFF
,      GP_AR_INVOICE_AMOUNT
,      GP_AR_CASH_APPLIED_AMOUNT
,      GP_AR_INVOICE_WRITEOFF_AMOUNT
,      GP_AR_CREDIT_MEMO_AMOUNT
,      GP_UNBILLED_RECEIVABLES
,      GP_UNEARNED_REVENUE
,      GP_AR_UNAPPR_INVOICE_AMOUNT
,      GP_AR_APPR_INVOICE_AMOUNT
,      GP_AR_AMOUNT_DUE
,      GP_AR_AMOUNT_OVERDUE
,      GL_CALENDAR_ID
,      PA_CALENDAR_ID
,      DANGLING_GL_RATE2_FLAG
,      DANGLING_PA_RATE2_FLAG
,      TASK_ID
,      GL_PERIOD_NAME
,      PA_PERIOD_NAME
,      TXN_CURRENCY_CODE
,      TXN_REVENUE
,      TXN_FUNDING
,      TXN_INITIAL_FUNDING_AMOUNT
,      TXN_ADDITIONAL_FUNDING_AMOUNT
,      TXN_CANCELLED_FUNDING_AMOUNT
,      TXN_FUNDING_ADJUSTMENT_AMOUNT
,      TXN_REVENUE_WRITEOFF
,      TXN_AR_INVOICE_AMOUNT
,      TXN_AR_CASH_APPLIED_AMOUNT
,      TXN_AR_INVOICE_WRITEOFF_AMOUNT
,      TXN_AR_CREDIT_MEMO_AMOUNT
,      TXN_UNBILLED_RECEIVABLES
,      TXN_UNEARNED_REVENUE
,      TXN_AR_UNAPPR_INVOICE_AMOUNT
,      TXN_AR_APPR_INVOICE_AMOUNT
,      TXN_AR_AMOUNT_DUE
,      TXN_AR_AMOUNT_OVERDUE
,      GG2_REVENUE
,      GG2_FUNDING
,      GG2_INITIAL_FUNDING_AMOUNT
,      GG2_ADDITIONAL_FUNDING_AMOUNT
,      GG2_CANCELLED_FUNDING_AMOUNT
,      GG2_FUNDING_ADJUSTMENT_AMOUNT
,      GG2_REVENUE_WRITEOFF
,      GG2_AR_INVOICE_AMOUNT
,      GG2_AR_CASH_APPLIED_AMOUNT
,      GG2_AR_INVOICE_WRITEOFF_AMOUNT
,      GG2_AR_CREDIT_MEMO_AMOUNT
,      GG2_UNBILLED_RECEIVABLES
,      GG2_UNEARNED_REVENUE
,      GG2_AR_UNAPPR_INVOICE_AMOUNT
,      GG2_AR_APPR_INVOICE_AMOUNT
,      GG2_AR_AMOUNT_DUE
,      GG2_AR_AMOUNT_OVERDUE
,      GP2_REVENUE
,      GP2_FUNDING
,      GP2_INITIAL_FUNDING_AMOUNT
,      GP2_ADDITIONAL_FUNDING_AMOUNT
,      GP2_CANCELLED_FUNDING_AMOUNT
,      GP2_FUNDING_ADJUSTMENT_AMOUNT
,      GP2_REVENUE_WRITEOFF
,      GP2_AR_INVOICE_AMOUNT
,      GP2_AR_CASH_APPLIED_AMOUNT
,      GP2_AR_INVOICE_WRITEOFF_AMOUNT
,      GP2_AR_CREDIT_MEMO_AMOUNT
,      GP2_UNBILLED_RECEIVABLES
,      GP2_UNEARNED_REVENUE
,      GP2_AR_UNAPPR_INVOICE_AMOUNT
,      GP2_AR_APPR_INVOICE_AMOUNT
,      GP2_AR_AMOUNT_DUE
,      GP2_AR_AMOUNT_OVERDUE
FROM PJI.PJI_FM_AGGR_ACT2#;

Dependencies

[top of page]

PJI.PJI_FM_AGGR_ACT2# references the following:

SchemaPJI
TablePJI_FM_AGGR_ACT2
PJI.PJI_FM_AGGR_ACT2# is referenced by following:

SchemaAPPS
SynonymPJI_FM_AGGR_ACT2