[Home] [Help] [Dependency Information]
Object Name: | MLOG$_PJI_AC_PROJ_F |
---|---|
Object Type: | TABLE |
Owner: | PJI |
Subobject Name: | |
Status: | VALID |
snapshot log for master table PJI.PJI_AC_PROJ_F
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 60 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVE_BACKLOG | NUMBER | |||
ADDITIONAL_FUNDING_AMOUNT | NUMBER | |||
ADDITIONAL_FUNDING_COUNT | NUMBER | |||
AR_AMOUNT_DUE | NUMBER | |||
AR_AMOUNT_OVERDUE | NUMBER | |||
AR_APPR_INVOICE_AMOUNT | NUMBER | |||
AR_APPR_INVOICE_COUNT | NUMBER | |||
AR_CASH_APPLIED_AMOUNT | NUMBER | |||
AR_COUNT_DUE | NUMBER | |||
AR_COUNT_OVERDUE | NUMBER | |||
AR_CREDIT_MEMO_AMOUNT | NUMBER | |||
AR_CREDIT_MEMO_COUNT | NUMBER | |||
AR_INVOICE_AMOUNT | NUMBER | |||
AR_INVOICE_COUNT | NUMBER | |||
AR_INVOICE_WRITEOFF_AMOUNT | NUMBER | |||
AR_INVOICE_WRITEOFF_COUNT | NUMBER | |||
AR_UNAPPR_INVOICE_AMOUNT | NUMBER | |||
AR_UNAPPR_INVOICE_COUNT | NUMBER | |||
CALENDAR_TYPE | VARCHAR2 | (30) | ||
CANCELLED_FUNDING_AMOUNT | NUMBER | |||
CANCELLED_FUNDING_COUNT | NUMBER | |||
CURRENCY_TYPE | VARCHAR2 | (30) | ||
DORMANT_BACKLOG_INACTIV | NUMBER | |||
DORMANT_BACKLOG_START | NUMBER | |||
FUNDING_ADJUSTMENT_AMOUNT | NUMBER | |||
FUNDING_ADJUSTMENT_COUNT | NUMBER | |||
INITIAL_FUNDING_AMOUNT | NUMBER | |||
INITIAL_FUNDING_COUNT | NUMBER | |||
LOST_BACKLOG | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | (15) | ||
PROJECT_ID | NUMBER | (15) | ||
PROJECT_ORGANIZATION_ID | NUMBER | (15) | ||
PROJECT_ORG_ID | NUMBER | (15) | ||
REVENUE | NUMBER | |||
REVENUE_AT_RISK | NUMBER | |||
REVENUE_WRITEOFF | NUMBER | |||
TIME_ID | NUMBER | (15) | ||
UNBILLED_RECEIVABLES | NUMBER | |||
UNEARNED_REVENUE | NUMBER | |||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) | ||
CURRENCY_CODE | VARCHAR2 | (30) | ||
CURR_RECORD_TYPE_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVE_BACKLOG
, ADDITIONAL_FUNDING_AMOUNT
, ADDITIONAL_FUNDING_COUNT
, AR_AMOUNT_DUE
, AR_AMOUNT_OVERDUE
, AR_APPR_INVOICE_AMOUNT
, AR_APPR_INVOICE_COUNT
, AR_CASH_APPLIED_AMOUNT
, AR_COUNT_DUE
, AR_COUNT_OVERDUE
, AR_CREDIT_MEMO_AMOUNT
, AR_CREDIT_MEMO_COUNT
, AR_INVOICE_AMOUNT
, AR_INVOICE_COUNT
, AR_INVOICE_WRITEOFF_AMOUNT
, AR_INVOICE_WRITEOFF_COUNT
, AR_UNAPPR_INVOICE_AMOUNT
, AR_UNAPPR_INVOICE_COUNT
, CALENDAR_TYPE
, CANCELLED_FUNDING_AMOUNT
, CANCELLED_FUNDING_COUNT
, CURRENCY_TYPE
, DORMANT_BACKLOG_INACTIV
, DORMANT_BACKLOG_START
, FUNDING_ADJUSTMENT_AMOUNT
, FUNDING_ADJUSTMENT_COUNT
, INITIAL_FUNDING_AMOUNT
, INITIAL_FUNDING_COUNT
, LOST_BACKLOG
, PERIOD_TYPE_ID
, PROJECT_ID
, PROJECT_ORGANIZATION_ID
, PROJECT_ORG_ID
, REVENUE
, REVENUE_AT_RISK
, REVENUE_WRITEOFF
, TIME_ID
, UNBILLED_RECEIVABLES
, UNEARNED_REVENUE
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
, CURRENCY_CODE
, CURR_RECORD_TYPE_ID
FROM PJI.MLOG$_PJI_AC_PROJ_F;
PJI.MLOG$_PJI_AC_PROJ_F does not reference any database object
PJI.MLOG$_PJI_AC_PROJ_F is referenced by following:
|
|
|