eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PJI.PJI_FM_EXTR_DINVCITM

Object Details

Object Name:	PJI_FM_EXTR_DINVCITM
Object Type:	TABLE
Owner:	PJI
FND Design Data:	PJI.PJI_FM_EXTR_DINVCITM
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:	APPS_TS_INTERFACE
PCT Free:	0
PCT Used:

Columns

Name	Datatype	Length	Mandatory
WORKER_ID	NUMBER		Yes
PROJECT_ORG_ID	NUMBER
PROJECT_ORGANIZATION_ID	NUMBER
PROJECT_ID	NUMBER
DRAFT_INVOICE_NUM	NUMBER
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)
INVOICE_LINE_TYPE	VARCHAR2	(30)
POU_INVOICE_AMOUNT	NUMBER
PRJ_INVOICE_AMOUNT	NUMBER
CUSTOMER_ID	NUMBER
APPROVED_FLAG	VARCHAR2	(1)
PJI_DATE_RANGE_FLAG	VARCHAR2	(1)
TRANSFER_STATUS_CODE	VARCHAR2	(1)
PJI_RECORD_TYPE	VARCHAR2	(1)
AR_INVOICE_COUNT	NUMBER
AR_INVOICE_WRITEOFF_COUNT	NUMBER
AR_CREDIT_MEMO_COUNT	NUMBER
AR_UNAPPR_INVOICE_COUNT	NUMBER
AR_APPR_INVOICE_COUNT	NUMBER

Query Text

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


SELECT WORKER_ID
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ID
,      DRAFT_INVOICE_NUM
,      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
,      INVOICE_LINE_TYPE
,      POU_INVOICE_AMOUNT
,      PRJ_INVOICE_AMOUNT
,      CUSTOMER_ID
,      APPROVED_FLAG
,      PJI_DATE_RANGE_FLAG
,      TRANSFER_STATUS_CODE
,      PJI_RECORD_TYPE
,      AR_INVOICE_COUNT
,      AR_INVOICE_WRITEOFF_COUNT
,      AR_CREDIT_MEMO_COUNT
,      AR_UNAPPR_INVOICE_COUNT
,      AR_APPR_INVOICE_COUNT
FROM PJI.PJI_FM_EXTR_DINVCITM;

Dependencies

[top of page]

PJI.PJI_FM_EXTR_DINVCITM does not reference any database object

PJI.PJI_FM_EXTR_DINVCITM is referenced by following:

APPS: PJI_FM_EXTR_DINVCITM