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

VIEW: APPS.PA_DRAFT_INVOICE_PP_V

Object Details
Object Name: PA_DRAFT_INVOICE_PP_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes
DRAFT_INVOICE_NUM NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
TRANSFER_STATUS_CODE VARCHAR2 (1) Yes
GENERATION_ERROR_FLAG VARCHAR2 (1) Yes
AGREEMENT_ID NUMBER (15) Yes
PA_DATE DATE

REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

CUSTOMER_BILL_SPLIT NUMBER (7)
BILL_THROUGH_DATE DATE

INVOICE_COMMENT VARCHAR2 (240)
APPROVED_DATE DATE

APPROVED_BY_PERSON_ID NUMBER (9)
RELEASED_DATE DATE

RELEASED_BY_PERSON_ID NUMBER (9)
INVOICE_DATE DATE

RA_INVOICE_NUMBER VARCHAR2 (20)
TRANSFERRED_DATE DATE

TRANSFER_REJECTION_REASON VARCHAR2 (250)
UNEARNED_REVENUE_CR NUMBER (22)
UNBILLED_RECEIVABLE_DR NUMBER (22)
GL_DATE DATE

SYSTEM_REFERENCE NUMBER (15)
DRAFT_INVOICE_NUM_CREDITED NUMBER (15)
CANCELED_FLAG VARCHAR2 (1)
CANCEL_CREDIT_MEMO_FLAG VARCHAR2 (1)
WRITE_OFF_FLAG VARCHAR2 (1)
CONVERTED_FLAG VARCHAR2 (1)
EXTRACTED_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
RETENTION_PERCENTAGE NUMBER (15)
INVOICE_SET_ID NUMBER (15)
ORG_ID NUMBER (15)
INV_CURRENCY_CODE VARCHAR2 (15)
INV_RATE_TYPE VARCHAR2 (30)
INV_RATE_DATE DATE

INV_EXCHANGE_RATE NUMBER

BILL_TO_ADDRESS_ID NUMBER

SHIP_TO_ADDRESS_ID NUMBER

PRC_GENERATED_FLAG VARCHAR2 (1)
RECEIVABLE_CODE_COMBINATION_ID NUMBER

ROUNDING_CODE_COMBINATION_ID NUMBER

UNBILLED_CODE_COMBINATION_ID NUMBER

UNEARNED_CODE_COMBINATION_ID NUMBER

WOFF_CODE_COMBINATION_ID NUMBER

ACCTD_CURR_CODE VARCHAR2 (15)
ACCTD_RATE_TYPE VARCHAR2 (30)
ACCTD_RATE_DATE DATE

ACCTD_EXCHG_RATE NUMBER

LANGUAGE VARCHAR2 (30)
CC_INVOICE_GROUP_CODE VARCHAR2 (1)
CC_PROJECT_ID NUMBER

IB_AP_TRANSFER_STATUS_CODE VARCHAR2 (1)
IB_AP_TRANSFER_ERROR_CODE VARCHAR2 (80)
INVPROC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_INVTRANS_RATE_TYPE VARCHAR2 (30)
PROJFUNC_INVTRANS_RATE_DATE DATE

PROJFUNC_INVTRANS_EX_RATE NUMBER

PA_PERIOD_NAME VARCHAR2 (15)
GL_PERIOD_NAME VARCHAR2 (15)
UBR_SUMMARY_ID NUMBER (15)
UER_SUMMARY_ID NUMBER (15)
UBR_UER_PROCESS_FLAG VARCHAR2 (1)
PJI_SUMMARIZED_FLAG VARCHAR2 (1)
RETENTION_INVOICE_FLAG VARCHAR2 (1)
RETN_CODE_COMBINATION_ID NUMBER

PURGE_FLAG VARCHAR2 (1)
CUSTOMER_ID NUMBER (15)
BILL_TO_CUSTOMER_ID NUMBER (15)
SHIP_TO_CUSTOMER_ID NUMBER (15)
BILL_TO_CONTACT_ID NUMBER (15)
SHIP_TO_CONTACT_ID NUMBER (15)
CREDIT_MEMO_REASON_CODE VARCHAR2 (30)
CONCESSION_FLAG VARCHAR2 (1)
RECORD_VERSION_NUMBER NUMBER

LAST_CREDIT_REQUEST_ID NUMBER

PAYMENT_SET_ID NUMBER (15)
ROW_ID ROWID (10)
PROJECT_ROLE_TYPE VARCHAR2 (20) Yes
PERSON_ID NUMBER (15) Yes
PROJECT_ROLE_ID NUMBER
Yes
Query Text

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


SELECT PROJECT_ID
,      DRAFT_INVOICE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      TRANSFER_STATUS_CODE
,      GENERATION_ERROR_FLAG
,      AGREEMENT_ID
,      PA_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CUSTOMER_BILL_SPLIT
,      BILL_THROUGH_DATE
,      INVOICE_COMMENT
,      APPROVED_DATE
,      APPROVED_BY_PERSON_ID
,      RELEASED_DATE
,      RELEASED_BY_PERSON_ID
,      INVOICE_DATE
,      RA_INVOICE_NUMBER
,      TRANSFERRED_DATE
,      TRANSFER_REJECTION_REASON
,      UNEARNED_REVENUE_CR
,      UNBILLED_RECEIVABLE_DR
,      GL_DATE
,      SYSTEM_REFERENCE
,      DRAFT_INVOICE_NUM_CREDITED
,      CANCELED_FLAG
,      CANCEL_CREDIT_MEMO_FLAG
,      WRITE_OFF_FLAG
,      CONVERTED_FLAG
,      EXTRACTED_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      RETENTION_PERCENTAGE
,      INVOICE_SET_ID
,      ORG_ID
,      INV_CURRENCY_CODE
,      INV_RATE_TYPE
,      INV_RATE_DATE
,      INV_EXCHANGE_RATE
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      PRC_GENERATED_FLAG
,      RECEIVABLE_CODE_COMBINATION_ID
,      ROUNDING_CODE_COMBINATION_ID
,      UNBILLED_CODE_COMBINATION_ID
,      UNEARNED_CODE_COMBINATION_ID
,      WOFF_CODE_COMBINATION_ID
,      ACCTD_CURR_CODE
,      ACCTD_RATE_TYPE
,      ACCTD_RATE_DATE
,      ACCTD_EXCHG_RATE
,      LANGUAGE
,      CC_INVOICE_GROUP_CODE
,      CC_PROJECT_ID
,      IB_AP_TRANSFER_STATUS_CODE
,      IB_AP_TRANSFER_ERROR_CODE
,      INVPROC_CURRENCY_CODE
,      PROJFUNC_INVTRANS_RATE_TYPE
,      PROJFUNC_INVTRANS_RATE_DATE
,      PROJFUNC_INVTRANS_EX_RATE
,      PA_PERIOD_NAME
,      GL_PERIOD_NAME
,      UBR_SUMMARY_ID
,      UER_SUMMARY_ID
,      UBR_UER_PROCESS_FLAG
,      PJI_SUMMARIZED_FLAG
,      RETENTION_INVOICE_FLAG
,      RETN_CODE_COMBINATION_ID
,      PURGE_FLAG
,      CUSTOMER_ID
,      BILL_TO_CUSTOMER_ID
,      SHIP_TO_CUSTOMER_ID
,      BILL_TO_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      CREDIT_MEMO_REASON_CODE
,      CONCESSION_FLAG
,      RECORD_VERSION_NUMBER
,      LAST_CREDIT_REQUEST_ID
,      PAYMENT_SET_ID
,      ROW_ID
,      PROJECT_ROLE_TYPE
,      PERSON_ID
,      PROJECT_ROLE_ID
FROM APPS.PA_DRAFT_INVOICE_PP_V;

Dependencies

[top of page]

APPS.PA_DRAFT_INVOICE_PP_V references the following:

SchemaAPPS
SynonymPA_DRAFT_INVOICES_ALL
SynonymPA_PROJECT_PARTIES
SynonymPA_PROJECT_ROLE_TYPES_B
SynonymPA_ROLE_CONTROLS
APPS.PA_DRAFT_INVOICE_PP_V is referenced by following:

SchemaAPPS
ViewPA_DRAFT_INVOICES_V