[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_AGGR_ACT5 |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_FM_AGGR_ACT5 |
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: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKER_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
PROJECT_ORG_ID | NUMBER | |||
PROJECT_ORGANIZATION_ID | NUMBER | |||
TIME_ID | NUMBER | |||
CALENDAR_TYPE | VARCHAR2 | (1) | ||
GL_CALENDAR_ID | NUMBER | (15) | ||
PA_CALENDAR_ID | NUMBER | (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 | |||
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 | |||
EOU_REVENUE | NUMBER | |||
EOU_FUNDING | NUMBER | |||
EOU_INITIAL_FUNDING_AMOUNT | NUMBER | |||
EOU_ADDITIONAL_FUNDING_AMOUNT | NUMBER | |||
EOU_CANCELLED_FUNDING_AMOUNT | NUMBER | |||
EOU_FUNDING_ADJUSTMENT_AMOUNT | NUMBER | |||
EOU_REVENUE_WRITEOFF | NUMBER | |||
EOU_AR_INVOICE_AMOUNT | NUMBER | |||
EOU_AR_CASH_APPLIED_AMOUNT | NUMBER | |||
EOU_AR_INVOICE_WRITEOFF_AMOUNT | NUMBER | |||
EOU_AR_CREDIT_MEMO_AMOUNT | NUMBER | |||
EOU_UNBILLED_RECEIVABLES | NUMBER | |||
EOU_UNEARNED_REVENUE | NUMBER | |||
EOU_AR_UNAPPR_INVOICE_AMOUNT | NUMBER | |||
EOU_AR_APPR_INVOICE_AMOUNT | NUMBER | |||
EOU_AR_AMOUNT_DUE | NUMBER | |||
EOU_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 | |||
G1_REVENUE | NUMBER | |||
G1_FUNDING | NUMBER | |||
G1_INITIAL_FUNDING_AMOUNT | NUMBER | |||
G1_ADDITIONAL_FUNDING_AMOUNT | NUMBER | |||
G1_CANCELLED_FUNDING_AMOUNT | NUMBER | |||
G1_FUNDING_ADJUSTMENT_AMOUNT | NUMBER | |||
G1_REVENUE_WRITEOFF | NUMBER | |||
G1_AR_INVOICE_AMOUNT | NUMBER | |||
G1_AR_CASH_APPLIED_AMOUNT | NUMBER | |||
G1_AR_INVOICE_WRITEOFF_AMOUNT | NUMBER | |||
G1_AR_CREDIT_MEMO_AMOUNT | NUMBER | |||
G1_UNBILLED_RECEIVABLES | NUMBER | |||
G1_UNEARNED_REVENUE | NUMBER | |||
G1_AR_UNAPPR_INVOICE_AMOUNT | NUMBER | |||
G1_AR_APPR_INVOICE_AMOUNT | NUMBER | |||
G1_AR_AMOUNT_DUE | NUMBER | |||
G1_AR_AMOUNT_OVERDUE | NUMBER | |||
G2_REVENUE | NUMBER | |||
G2_FUNDING | NUMBER | |||
G2_INITIAL_FUNDING_AMOUNT | NUMBER | |||
G2_ADDITIONAL_FUNDING_AMOUNT | NUMBER | |||
G2_CANCELLED_FUNDING_AMOUNT | NUMBER | |||
G2_FUNDING_ADJUSTMENT_AMOUNT | NUMBER | |||
G2_REVENUE_WRITEOFF | NUMBER | |||
G2_AR_INVOICE_AMOUNT | NUMBER | |||
G2_AR_CASH_APPLIED_AMOUNT | NUMBER | |||
G2_AR_INVOICE_WRITEOFF_AMOUNT | NUMBER | |||
G2_AR_CREDIT_MEMO_AMOUNT | NUMBER | |||
G2_UNBILLED_RECEIVABLES | NUMBER | |||
G2_UNEARNED_REVENUE | NUMBER | |||
G2_AR_UNAPPR_INVOICE_AMOUNT | NUMBER | |||
G2_AR_APPR_INVOICE_AMOUNT | NUMBER | |||
G2_AR_AMOUNT_DUE | NUMBER | |||
G2_AR_AMOUNT_OVERDUE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT WORKER_ID
, PROJECT_ID
, PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID
, TIME_ID
, CALENDAR_TYPE
, GL_CALENDAR_ID
, PA_CALENDAR_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
, EOU_REVENUE
, EOU_FUNDING
, EOU_INITIAL_FUNDING_AMOUNT
, EOU_ADDITIONAL_FUNDING_AMOUNT
, EOU_CANCELLED_FUNDING_AMOUNT
, EOU_FUNDING_ADJUSTMENT_AMOUNT
, EOU_REVENUE_WRITEOFF
, EOU_AR_INVOICE_AMOUNT
, EOU_AR_CASH_APPLIED_AMOUNT
, EOU_AR_INVOICE_WRITEOFF_AMOUNT
, EOU_AR_CREDIT_MEMO_AMOUNT
, EOU_UNBILLED_RECEIVABLES
, EOU_UNEARNED_REVENUE
, EOU_AR_UNAPPR_INVOICE_AMOUNT
, EOU_AR_APPR_INVOICE_AMOUNT
, EOU_AR_AMOUNT_DUE
, EOU_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_ACT5;
PJI.PJI_FM_AGGR_ACT5 does not reference any database object
PJI.PJI_FM_AGGR_ACT5 is referenced by following:
|
|
|