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

VIEW: PJI.PJI_FM_EXTR_DINVCITM#

Object Details
Object Name: PJI_FM_EXTR_DINVCITM#
Object Type: VIEW
Owner: PJI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
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# references the following:

SchemaPJI
TablePJI_FM_EXTR_DINVCITM
PJI.PJI_FM_EXTR_DINVCITM# is referenced by following:

SchemaAPPS
SynonymPJI_FM_EXTR_DINVCITM