[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_AGGR_ACT4 |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_FM_AGGR_ACT4 |
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_TX_DATA |
---|---|
PCT Free: | 0 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PJI_FM_AGGR_ACT4_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PROJECT_ID |
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 |
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;
PJI.PJI_FM_AGGR_ACT4 does not reference any database object
PJI.PJI_FM_AGGR_ACT4 is referenced by following:
|
|
|