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

TABLE: PJI.PJI_FM_AGGR_ACT4

Object Details
Object Name: PJI_FM_AGGR_ACT4
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_FM_AGGR_ACT4
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: 0
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJI_FM_AGGR_ACT4_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15)
Summarization state data
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
TASK_ID NUMBER (15)
Identifier of the Task
PERIOD_TYPE VARCHAR2 (15)
PERIOD_ID NUMBER (15)
Period Identifier
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
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
G1_REVENUE NUMBER

Revenue converted to primary global currency
G1_FUNDING NUMBER

Funding converted to primary global currency
G1_INITIAL_FUNDING_AMOUNT NUMBER

Initial Funding Amount converted to primary global currency
G1_ADDITIONAL_FUNDING_AMOUNT NUMBER

Additional Funding Amount converted to primary global currency
G1_CANCELLED_FUNDING_AMOUNT NUMBER

Cancelled Funding Amount converted to primary global currency
G1_FUNDING_ADJUSTMENT_AMOUNT NUMBER

Funding Adjustment Amount converted to primary global currency
G1_REVENUE_WRITEOFF NUMBER

Revenue Writeoff converted to primary global currency
G1_AR_INVOICE_AMOUNT NUMBER

AR Invoice Amount converted to primary global currency
G1_AR_CASH_APPLIED_AMOUNT NUMBER

AR Cash Applied Amount converted to primary global currency
G1_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

AR Invoice Writeoff Amount converted to primary global currency
G1_AR_CREDIT_MEMO_AMOUNT NUMBER

AR Credit Memo Amount converted to primary global currency
G1_UNBILLED_RECEIVABLES NUMBER

Unbilled Receivables converted to primary global currency
G1_UNEARNED_REVENUE NUMBER

Unearned Revenue converted to primary global currency
G1_AR_UNAPPR_INVOICE_AMOUNT NUMBER

AR Unapproved Invoice Amount converted to primary global currency
G1_AR_APPR_INVOICE_AMOUNT NUMBER

AR Approved Invoice Amount converted to primary global currency
G1_AR_AMOUNT_DUE NUMBER

AR Amount Due converted to primary global currency
G1_AR_AMOUNT_OVERDUE NUMBER

AR Amount Overdue converted to primary global currency
G2_REVENUE NUMBER

Revenue converted to secondary global currency
G2_FUNDING NUMBER

Funding converted to secondary global currency
G2_INITIAL_FUNDING_AMOUNT NUMBER

Initial Funding Amount converted to secondary global currency
G2_ADDITIONAL_FUNDING_AMOUNT NUMBER

Additional Funding Amount converted to secondary global currency
G2_CANCELLED_FUNDING_AMOUNT NUMBER

Cancelled Funding Amount converted to secondary global currency
G2_FUNDING_ADJUSTMENT_AMOUNT NUMBER

Funding Adjustment Amount converted to secondary global currency
G2_REVENUE_WRITEOFF NUMBER

Revenue Writeoff converted to secondary global currency
G2_AR_INVOICE_AMOUNT NUMBER

AR Invoice Amount converted to secondary global currency
G2_AR_CASH_APPLIED_AMOUNT NUMBER

AR Cash Applied Amount converted to secondary global currency
G2_AR_INVOICE_WRITEOFF_AMOUNT NUMBER

AR Invoice Writeoff Amount converted to secondary global currency
G2_AR_CREDIT_MEMO_AMOUNT NUMBER

AR Credit Memo Amount converted to secondary global currency
G2_UNBILLED_RECEIVABLES NUMBER

Unbilled Receivables converted to secondary global currency
G2_UNEARNED_REVENUE NUMBER

Unearned Revenue converted to secondary global currency
G2_AR_UNAPPR_INVOICE_AMOUNT NUMBER

AR Unapproved Invoice Amount converted to secondary global currency
G2_AR_APPR_INVOICE_AMOUNT NUMBER

AR Approved Invoice Amount converted to secondary global currency
G2_AR_AMOUNT_DUE NUMBER

AR Amount Due converted to secondary global currency
G2_AR_AMOUNT_OVERDUE NUMBER

AR Amount Overdue converted to secondary global 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
,      TASK_ID
,      PERIOD_TYPE
,      PERIOD_ID
,      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
,      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
,      G1_REVENUE
,      G1_FUNDING
,      G1_INITIAL_FUNDING_AMOUNT
,      G1_ADDITIONAL_FUNDING_AMOUNT
,      G1_CANCELLED_FUNDING_AMOUNT
,      G1_FUNDING_ADJUSTMENT_AMOUNT
,      G1_REVENUE_WRITEOFF
,      G1_AR_INVOICE_AMOUNT
,      G1_AR_CASH_APPLIED_AMOUNT
,      G1_AR_INVOICE_WRITEOFF_AMOUNT
,      G1_AR_CREDIT_MEMO_AMOUNT
,      G1_UNBILLED_RECEIVABLES
,      G1_UNEARNED_REVENUE
,      G1_AR_UNAPPR_INVOICE_AMOUNT
,      G1_AR_APPR_INVOICE_AMOUNT
,      G1_AR_AMOUNT_DUE
,      G1_AR_AMOUNT_OVERDUE
,      G2_REVENUE
,      G2_FUNDING
,      G2_INITIAL_FUNDING_AMOUNT
,      G2_ADDITIONAL_FUNDING_AMOUNT
,      G2_CANCELLED_FUNDING_AMOUNT
,      G2_FUNDING_ADJUSTMENT_AMOUNT
,      G2_REVENUE_WRITEOFF
,      G2_AR_INVOICE_AMOUNT
,      G2_AR_CASH_APPLIED_AMOUNT
,      G2_AR_INVOICE_WRITEOFF_AMOUNT
,      G2_AR_CREDIT_MEMO_AMOUNT
,      G2_UNBILLED_RECEIVABLES
,      G2_UNEARNED_REVENUE
,      G2_AR_UNAPPR_INVOICE_AMOUNT
,      G2_AR_APPR_INVOICE_AMOUNT
,      G2_AR_AMOUNT_DUE
,      G2_AR_AMOUNT_OVERDUE
FROM PJI.PJI_FM_AGGR_ACT4;

Dependencies

[top of page]

PJI.PJI_FM_AGGR_ACT4 does not reference any database object

PJI.PJI_FM_AGGR_ACT4 is referenced by following:

SchemaPJI
ViewPJI_FM_AGGR_ACT4#