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

TABLE: PJI.PJI_FM_AGGR_ACT1

Object Details
Object Name: PJI_FM_AGGR_ACT1
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_FM_AGGR_ACT1
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
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
CUSTOMER_ID NUMBER

Identifier of the Customer
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 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 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 Adjustment 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
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 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
Query Text

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


SELECT WORKER_ID
,      PROJECT_ID
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      CUSTOMER_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
,      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
FROM PJI.PJI_FM_AGGR_ACT1;

Dependencies

[top of page]

PJI.PJI_FM_AGGR_ACT1 does not reference any database object

PJI.PJI_FM_AGGR_ACT1 is referenced by following:

SchemaPJI
ViewPJI_FM_AGGR_ACT1#