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

TABLE: PJI.PJI_FM_EXTR_DINVC

Object Details
Object Name: PJI_FM_EXTR_DINVC
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_FM_EXTR_DINVC
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_INTERFACE
PCT Free: 0
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10) Yes
WORKER_ID NUMBER
Yes
PROJECT_ORG_ID NUMBER

PROJECT_ORGANIZATION_ID NUMBER

PROJECT_ID NUMBER

PJI_PROJECT_STATUS VARCHAR2 (1)
DRAFT_INVOICE_NUM NUMBER

UNBILLED_RECEIVABLE_DR NUMBER

UNEARNED_REVENUE_CR NUMBER

TRANSFER_STATUS_CODE VARCHAR2 (1)
GL_DATE DATE

PA_DATE DATE

SYSTEM_REFERENCE NUMBER

APPROVED_DATE DATE

APPROVED_BY_PERSON_ID NUMBER

CANCEL_CREDIT_MEMO_FLAG VARCHAR2 (1)
WRITE_OFF_FLAG VARCHAR2 (1)
INTER_COMPANY_BILLING_FLAG VARCHAR2 (1)
PJI_SUMMARIZED_FLAG VARCHAR2 (1)
APPROVED_FLAG VARCHAR2 (1)
PJI_DATE_RANGE_FLAG VARCHAR2 (1)
CUSTOMER_ID NUMBER

Query Text

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


SELECT ROW_ID
,      WORKER_ID
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ID
,      PJI_PROJECT_STATUS
,      DRAFT_INVOICE_NUM
,      UNBILLED_RECEIVABLE_DR
,      UNEARNED_REVENUE_CR
,      TRANSFER_STATUS_CODE
,      GL_DATE
,      PA_DATE
,      SYSTEM_REFERENCE
,      APPROVED_DATE
,      APPROVED_BY_PERSON_ID
,      CANCEL_CREDIT_MEMO_FLAG
,      WRITE_OFF_FLAG
,      INTER_COMPANY_BILLING_FLAG
,      PJI_SUMMARIZED_FLAG
,      APPROVED_FLAG
,      PJI_DATE_RANGE_FLAG
,      CUSTOMER_ID
FROM PJI.PJI_FM_EXTR_DINVC;

Dependencies

[top of page]

PJI.PJI_FM_EXTR_DINVC does not reference any database object

PJI.PJI_FM_EXTR_DINVC is referenced by following:

SchemaPJI
ViewPJI_FM_EXTR_DINVC#