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

TABLE: PJI.PJI_FM_AGGR_ACT2

Object Details
Object Name: PJI_FM_AGGR_ACT2
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_FM_AGGR_ACT2
Subobject Name:
Status: VALID


This is an intermediate summarization table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 0
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER

Summarization state data
DANGLING_GL_RATE_FLAG VARCHAR2 (1)
Indicates whether primary global currency rate is available on the GL transaction date
DANGLING_PA_RATE_FLAG VARCHAR2 (1)
Indicates whether primary global currency rate is available on the PA transaction date
DANGLING_EN_TIME_FLAG VARCHAR2 (1)
Indicates whether the project GL date is outside the enterprise calendar date range
DANGLING_GL_TIME_FLAG VARCHAR2 (1)
Indicates whether the project GL date is outside the GL calendar date range
DANGLING_PA_TIME_FLAG VARCHAR2 (1)
Indicates whether the project GL date is outside the PA calendar date range
ROW_ID ROWID (10)
Dangling table ROWID
PROJECT_ID NUMBER

Identifier of the Project
PROJECT_ORG_ID NUMBER

Identifier of the Project Operating Unit
PROJECT_ORGANIZATION_ID NUMBER

Identifier of the Project Organization
GL_TIME_ID NUMBER

GL transaction date
PA_TIME_ID NUMBER

PA transaction date
PRJ_REVENUE NUMBER

Revenue by project currency
PRJ_FUNDING NUMBER

Funding by project currency
PRJ_INITIAL_FUNDING_AMOUNT NUMBER

Initial Funding Amount by project currency
PRJ_ADDITIONAL_FUNDING_AMOUNT NUMBER

Additional Funding Amount by project currency
PRJ_CANCELLED_FUNDING_AMOUNT NUMBER

Cancelled Funding Amount by project currency
PRJ_FUNDING_ADJUSTMENT_AMOUNT NUMBER

Funding Adjustment Amount by project currency
PRJ_REVENUE_WRITEOFF NUMBER

Revenue Writeoff by project currency
PRJ_AR_INVOICE_AMOUNT NUMBER

AR Invoice Amount by project currency
PRJ_AR_CASH_APPLIED_AMOUNT NUMBER

AR Cash Applied Amount by project currency
PRJ_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

AR Invoice Writeoff Amount by project currency
PRJ_AR_CREDIT_MEMO_AMOUNT NUMBER

AR Credit Memo Amount by project currency
PRJ_UNBILLED_RECEIVABLES NUMBER

Unbilled Receivables by project currency
PRJ_UNEARNED_REVENUE NUMBER

Unearned Revenue by project currency
PRJ_AR_UNAPPR_INVOICE_AMOUNT NUMBER

AR Unapproved Invoice Amount by project currency
PRJ_AR_APPR_INVOICE_AMOUNT NUMBER

AR Approved Invoice Amount by project currency
PRJ_AR_AMOUNT_DUE NUMBER

AR Amount Due by project currency
PRJ_AR_AMOUNT_OVERDUE NUMBER

AR Amount Overdue by project currency
POU_REVENUE NUMBER

Revenue by project functional currency
POU_FUNDING NUMBER

Funding by project functional currency
POU_INITIAL_FUNDING_AMOUNT NUMBER

Initial Funding Amount by project functional currency
POU_ADDITIONAL_FUNDING_AMOUNT NUMBER

Additional Funding Amount by project functional currency
POU_CANCELLED_FUNDING_AMOUNT NUMBER

Cancelled Funding Amount by project functional currency
POU_FUNDING_ADJUSTMENT_AMOUNT NUMBER

Funding Adjustment Amount by project functional currency
POU_REVENUE_WRITEOFF NUMBER

Revenue Writeoff by project functional currency
POU_AR_INVOICE_AMOUNT NUMBER

AR Invoice Amount by project functional currency
POU_AR_CASH_APPLIED_AMOUNT NUMBER

AR Cash Applied Amount by project functional currency
POU_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

AR Invoice Writeoff Amount by project functional currency
POU_AR_CREDIT_MEMO_AMOUNT NUMBER

AR Credit Memo Amount by project functional currency
POU_UNBILLED_RECEIVABLES NUMBER

Unbilled Receivables by project functional currency
POU_UNEARNED_REVENUE NUMBER

Unearned Revenue by project functional currency
POU_AR_UNAPPR_INVOICE_AMOUNT NUMBER

AR Unapproved Invoice Amount by project functional currency
POU_AR_APPR_INVOICE_AMOUNT NUMBER

AR Approved Invoice Amount by project functional currency
POU_AR_AMOUNT_DUE NUMBER

AR Amount Due by project functional currency
POU_AR_AMOUNT_OVERDUE NUMBER

AR Amount Overdue by project functional currency
INITIAL_FUNDING_COUNT NUMBER

Initial Funding Count
ADDITIONAL_FUNDING_COUNT NUMBER

Additional Funding Count
CANCELLED_FUNDING_COUNT NUMBER

Cancelled Funding Count
FUNDING_ADJUSTMENT_COUNT NUMBER

Funding Adjustments Count
AR_INVOICE_COUNT NUMBER

AR Invoice Count
AR_CASH_APPLIED_COUNT NUMBER

AR Cash Applied Count
AR_INVOICE_WRITEOFF_COUNT NUMBER

AR Invoice Writeoff Count
AR_CREDIT_MEMO_COUNT NUMBER

AR Credit Memo Count
AR_UNAPPR_INVOICE_COUNT NUMBER

AR Unapproved Invoice Count
AR_APPR_INVOICE_COUNT NUMBER

AR Approved Invoice Count
AR_COUNT_DUE NUMBER

AR Count Due
AR_COUNT_OVERDUE NUMBER

AR Count Overdue
GG_REVENUE NUMBER

Revenue converted to primary global currency on GL transaction date
GG_FUNDING NUMBER

Funding converted to primary global currency on GL transaction date
GG_INITIAL_FUNDING_AMOUNT NUMBER

Initial Funding Amount converted to primary global currency on GL transaction date
GG_ADDITIONAL_FUNDING_AMOUNT NUMBER

Additional Funding Amount converted to primary global currency on GL transaction date
GG_CANCELLED_FUNDING_AMOUNT NUMBER

Cancelled Funding Amount converted to primary global currency on GL transaction date
GG_FUNDING_ADJUSTMENT_AMOUNT NUMBER

Funding Adjustment Amount converted to primary global currency on GL transaction date
GG_REVENUE_WRITEOFF NUMBER

Revenue Writeoff converted to primary global currency on GL transaction date
GG_AR_INVOICE_AMOUNT NUMBER

AR Invoice Amount converted to primary global currency on GL transaction date
GG_AR_CASH_APPLIED_AMOUNT NUMBER

AR Cash Applied Amount converted to primary global currency on GL transaction date
GG_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

AR Invoice Writeoff Amount converted to primary global currency on GL transaction date
GG_AR_CREDIT_MEMO_AMOUNT NUMBER

AR Credit Memo Amount converted to primary global currency on GL transaction date
GG_UNBILLED_RECEIVABLES NUMBER

Unbilled Receivables converted to primary global currency on GL transaction date
GG_UNEARNED_REVENUE NUMBER

Unearned Revenue converted to primary global currency on GL transaction date
GG_AR_UNAPPR_INVOICE_AMOUNT NUMBER

AR Unapproved Invoice Amount converted to primary global currency on GL transaction date
GG_AR_APPR_INVOICE_AMOUNT NUMBER

AR Approved Invoice Amount converted to primary global currency on GL transaction date
GG_AR_AMOUNT_DUE NUMBER

AR Amount Due converted to primary global currency on GL transaction date
GG_AR_AMOUNT_OVERDUE NUMBER

AR Amount Overdue converted to primary global currency on GL transaction date
GP_REVENUE NUMBER

Revenue converted to primary global currency on PA transaction date
GP_FUNDING NUMBER

Funding converted to primary global currency on PA transaction date
GP_INITIAL_FUNDING_AMOUNT NUMBER

Initial Funding Amount converted to primary global currency on PA transaction date
GP_ADDITIONAL_FUNDING_AMOUNT NUMBER

Additional Funding Amount converted to primary global currency on PA transaction date
GP_CANCELLED_FUNDING_AMOUNT NUMBER

Cancelled Funding Amount converted to primary global currency on PA transaction date
GP_FUNDING_ADJUSTMENT_AMOUNT NUMBER

Funding Adjustment Amount converted to primary global currency on PA transaction date
GP_REVENUE_WRITEOFF NUMBER

Revenue Writeoff converted to primary global currency on PA transaction date
GP_AR_INVOICE_AMOUNT NUMBER

AR Invoice Amount converted to primary global currency on PA transaction date
GP_AR_CASH_APPLIED_AMOUNT NUMBER

AR Cash Applied Amount converted to primary global currency on PA transaction date
GP_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

AR Invoice Writeoff Amount converted to primary global currency on PA transaction date
GP_AR_CREDIT_MEMO_AMOUNT NUMBER

AR Credit Memo Amount converted to primary global currency on PA transaction date
GP_UNBILLED_RECEIVABLES NUMBER

Unbilled Receivables converted to primary global currency on PA transaction date
GP_UNEARNED_REVENUE NUMBER

Unearned Revenue converted to primary global currency on PA transaction date
GP_AR_UNAPPR_INVOICE_AMOUNT NUMBER

AR Unapproved Invoice Amount converted to primary global currency on PA transaction date
GP_AR_APPR_INVOICE_AMOUNT NUMBER

AR Approved Invoice Amount converted to primary global currency on PA transaction date
GP_AR_AMOUNT_DUE NUMBER

AR Amount Due converted to primary global currency on PA transaction date
GP_AR_AMOUNT_OVERDUE NUMBER

AR Amount Overdue converted to primary global currency on PA transaction date
GL_CALENDAR_ID NUMBER

GL calendar lookup
PA_CALENDAR_ID NUMBER

PA calendar lookup
DANGLING_GL_RATE2_FLAG VARCHAR2 (1)
Indicates whether secondary global currency rate is available on the GL transaction date
DANGLING_PA_RATE2_FLAG VARCHAR2 (1)
Indicates whether secondary global currency rate is available on the PA transaction date
TASK_ID NUMBER

Identifier of the Task
GL_PERIOD_NAME VARCHAR2 (15)
GL Period Name
PA_PERIOD_NAME VARCHAR2 (15)
PA Period Name
TXN_CURRENCY_CODE VARCHAR2 (30)
Transaction Currency Code
TXN_REVENUE NUMBER

Revenue by transaction currency
TXN_FUNDING NUMBER

Funding by transaction currency
TXN_INITIAL_FUNDING_AMOUNT NUMBER

Initial Funding Amount by transaction currency
TXN_ADDITIONAL_FUNDING_AMOUNT NUMBER

Additional Funding Amount by transaction currency
TXN_CANCELLED_FUNDING_AMOUNT NUMBER

Cancelled Funding Amount by transaction currency
TXN_FUNDING_ADJUSTMENT_AMOUNT NUMBER

Funding Adjustment Amount by transaction currency
TXN_REVENUE_WRITEOFF NUMBER

Revenue Writeoff by transaction currency
TXN_AR_INVOICE_AMOUNT NUMBER

AR Invoice Amount by transaction currency
TXN_AR_CASH_APPLIED_AMOUNT NUMBER

AR Cash Applied Amount by transaction currency
TXN_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

AR Invoice Writeoff Amount by transaction currency
TXN_AR_CREDIT_MEMO_AMOUNT NUMBER

AR Credit Memo Amount by transaction currency
TXN_UNBILLED_RECEIVABLES NUMBER

Unbilled Receivables by transaction currency
TXN_UNEARNED_REVENUE NUMBER

Unearned Revenue by transaction currency
TXN_AR_UNAPPR_INVOICE_AMOUNT NUMBER

AR Unapproved Invoice Amount by transaction currency
TXN_AR_APPR_INVOICE_AMOUNT NUMBER

AR Approved Invoice Amount by transaction currency
TXN_AR_AMOUNT_DUE NUMBER

AR Amount Due by transaction currency
TXN_AR_AMOUNT_OVERDUE NUMBER

AR Amount Overdue by transaction currency
GG2_REVENUE NUMBER

Revenue converted to secondary global currency on GL transaction date
GG2_FUNDING NUMBER

Funding converted to secondary global currency on GL transaction date
GG2_INITIAL_FUNDING_AMOUNT NUMBER

Initial Funding Amount converted to secondary global currency on GL transaction date
GG2_ADDITIONAL_FUNDING_AMOUNT NUMBER

Additional Funding Amount converted to secondary global currency on GL transaction date
GG2_CANCELLED_FUNDING_AMOUNT NUMBER

Cancelled Funding Amount converted to secondary global currency on GL transaction date
GG2_FUNDING_ADJUSTMENT_AMOUNT NUMBER

Funding Adjustment Amount 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_AR_INVOICE_AMOUNT NUMBER

AR Invoice Amount converted to secondary global currency on GL transaction date
GG2_AR_CASH_APPLIED_AMOUNT NUMBER

AR Cash Applied Amount converted to secondary global currency on GL transaction date
GG2_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

AR Invoice Writeoff Amount converted to secondary global currency on GL transaction date
GG2_AR_CREDIT_MEMO_AMOUNT NUMBER

AR Credit Memo Amount converted to secondary global currency on GL transaction date
GG2_UNBILLED_RECEIVABLES NUMBER

Unbilled Receivables converted to secondary global currency on GL transaction date
GG2_UNEARNED_REVENUE NUMBER

Unearned Revenue converted to secondary global currency on GL transaction date
GG2_AR_UNAPPR_INVOICE_AMOUNT NUMBER

AR Unapproved Invoice Amount converted to secondary global currency on GL transaction date
GG2_AR_APPR_INVOICE_AMOUNT NUMBER

AR Approved Invoice Amount converted to secondary global currency on GL transaction date
GG2_AR_AMOUNT_DUE NUMBER

AR Amount Due converted to secondary global currency on GL transaction date
GG2_AR_AMOUNT_OVERDUE NUMBER

AR Amount Overdue converted to secondary global currency on GL transaction date
GP2_REVENUE NUMBER

Revenue converted to secondary global currency on PA transaction date
GP2_FUNDING NUMBER

Funding converted to secondary global currency on PA transaction date
GP2_INITIAL_FUNDING_AMOUNT NUMBER

Initial Funding Amount converted to secondary global currency on PA transaction date
GP2_ADDITIONAL_FUNDING_AMOUNT NUMBER

Additional Funding Amount converted to secondary global currency on PA transaction date
GP2_CANCELLED_FUNDING_AMOUNT NUMBER

Cancelled Funding Amount converted to secondary global currency on PA transaction date
GP2_FUNDING_ADJUSTMENT_AMOUNT NUMBER

Funding Adjustment Amount 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_AR_INVOICE_AMOUNT NUMBER

AR Invoice Amount converted to secondary global currency on PA transaction date
GP2_AR_CASH_APPLIED_AMOUNT NUMBER

AR Cash Applied Amount converted to secondary global currency on PA transaction date
GP2_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

AR Invoice Writeoff Amount converted to secondary global currency on PA transaction date
GP2_AR_CREDIT_MEMO_AMOUNT NUMBER

AR Credit Memo Amount converted to secondary global currency on PA transaction date
GP2_UNBILLED_RECEIVABLES NUMBER

Unbilled Receivables converted to secondary global currency on PA transaction date
GP2_UNEARNED_REVENUE NUMBER

Unearned Revenue converted to secondary global currency on PA transaction date
GP2_AR_UNAPPR_INVOICE_AMOUNT NUMBER

AR Unapproved Invoice Amount converted to secondary global currency on PA transaction date
GP2_AR_APPR_INVOICE_AMOUNT NUMBER

AR Approved Invoice Amount converted to secondary global currency on PA transaction date
GP2_AR_AMOUNT_DUE NUMBER

AR Amount Due converted to secondary global currency on PA transaction date
GP2_AR_AMOUNT_OVERDUE NUMBER

AR Amount Overdue converted to secondary global currency on PA transaction date
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 does not reference any database object

PJI.PJI_FM_AGGR_ACT2 is referenced by following:

SchemaPJI
ViewPJI_FM_AGGR_ACT2#