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

VIEW: APPS.PA_PWP_CUSTOMER_INVOICE_V

Object Details
Object Name: PA_PWP_CUSTOMER_INVOICE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_PWP_CUSTOMER_INVOICE_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DRAFT_INVOICE_NUM NUMBER (15) Yes Draft invoice number
RA_INVOICE_NUMBER VARCHAR2 (20)
AR invoice number
CUSTOMER_NAME VARCHAR2 (360)
Customer name
CUSTOMER_NUMBER VARCHAR2 (30)
Customer number
AGREEMENT_NUM VARCHAR2 (50)
Agreement number
BILL_THROUGH_DATE DATE

The date through which to include expenditure items and events in the invoice. Expenditure items with the expenditure item date on or before the bill through date and events with completion dates on or before the bill through date may be included in an invoice
INVOICE_CLASS VARCHAR2 (80)
Invoice class
CREDIT_OF NUMBER (15)
The draft invoice number that is credited by this draft invoice
INVOICE_DATE DATE

The invoice date is passed to Oracle Receivables and is used to calculate the invoice due date
INVOICE_STATUS_M VARCHAR2 (80)
Invoice status
PROJFUNC_INVTRANS_RATE_TYPE VARCHAR2 (30)
Exchange rate type is used for converting project functional currency to invoice transaction currency
PROJFUNC_INVTRANS_RATE_DATE DATE

Exchange rate date is used for converting project functional currency to invoice transaction currency
PROJECT_ID NUMBER (15) Yes Project Id
INVOICE_COUNT NUMBER

Number of supplier invoices linked to the draft invoice
PFC_LINK_AP_AMOUNT NUMBER

Invoice amount of the linked supplier in project functional currency
PC_LINK_AP_AMOUNT NUMBER

Invoice amount of the linked supplier in project currency
INV_CURRENCY_CODE VARCHAR2 (15)
Invoice currency code
INVOICE_INV_AMOUNT NUMBER

Line amount in invoice currency
INVOICE_CURR_PER_INV_AMOUNT NUMBER

Invoice amount for the current period in invoice currency
AR_INV_RECIEPT_AMOUNT NUMBER

Reciept amount in invoice currency
AR_INV_CURR_PER_RECIEPT_AMOUNT NUMBER

Reciept amount for the current period in invoice currency
AR_OUTSTANDING_AMOUNT NUMBER

Outstanding amount in invoice currency
AR_INV_ADJUSTMENT_AMOUNT NUMBER

Adjustment amount in invoice currency
INV_LINE_AMOUNT NUMBER

Line amount in invoice currency
AR_INV_TAX_AMOUNT NUMBER

Tax amount in invoice currency
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
Line amount in invoice currency
PFC_RATE NUMBER

PROJFUNC_BILL_AMOUNT NUMBER

Invoice amount in project functional currency
PROJFUNC_CURR_PER_BILL_AMOUNT NUMBER

Invoice amount for the current period in project functional currency
AR_PFC_RECIEPT_AMOUNT NUMBER

Reciept amount in project functional currency
AR_PFC_CURR_PER_RECIEPT_AMOUNT NUMBER

Reciept amount for the current period in project functional currency
AR_PFC_OUTSTANDING_AMOUNT NUMBER

Outstanding amount in project functional currency
AR_PFC_ADJUSTMENT_AMOUNT NUMBER

Adjustment amount in project functional currency
PFC_LINE_AMOUNT NUMBER

Line amount in project functional currency
AR_PFC_TAX_AMOUNT NUMBER

Tax amount in project functional currency
PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project currency code
PROJ_BILL_AMOUNT NUMBER

Invoice amount in project currency
PROJ_CURR_PER_BILL_AMOUNT NUMBER

Invoice amount for the current period in project currency
AR_PC_RECIEPT_AMOUNT NUMBER

Receipt amount in the project currency
AR_PC_CURR_PER_RECIEPT_AMOUNT NUMBER

Reciept amount for the current period in project currency
AR_PC_OUTSTANDING_AMOUNT NUMBER

Outstanding amount in project currency
AR_PC_ADJUSTMENT_AMOUNT NUMBER

Adjutment amount in project currency
PC_LINE_AMOUNT NUMBER

Line amount in project currency
AR_PC_TAX_AMOUNT NUMBER

Tax amount in project currency
GL_DATE DATE

Gl date of the customer invoice
APPROVED_DATE DATE

Approval date of the customer invoice
RELEASED_DATE DATE

Date when the customer invoice was released
BILL_TO_ADDRESS VARCHAR2 (400)
Address, as per the customer invoice, where the bill will be sent
SHIP_TO_ADDRESS VARCHAR2 (400)
Address, as per the customer invoice, where the shipment will be sent
BILL_TO_CUST_NAME VARCHAR2 (100)
Name of the customer, as per the customer invoice, against whom the bill will be generated
SHIP_TO_CUST_NAME VARCHAR2 (100)
Name of the customer, as per the customer invoice, to whom the shipment will be sent
BILL_TO_CUST_NUMBER VARCHAR2 (30)
Customer number, as per the customer invoice, against whom the bill will be generated
SHIP_TO_CUST_NUMBER VARCHAR2 (30)
Identifying number of the customer, as per the customer invoice, to whom the shipment will be sent
Query Text

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


SELECT DRAFT_INVOICE_NUM
,      RA_INVOICE_NUMBER
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      AGREEMENT_NUM
,      BILL_THROUGH_DATE
,      INVOICE_CLASS
,      CREDIT_OF
,      INVOICE_DATE
,      INVOICE_STATUS_M
,      PROJFUNC_INVTRANS_RATE_TYPE
,      PROJFUNC_INVTRANS_RATE_DATE
,      PROJECT_ID
,      INVOICE_COUNT
,      PFC_LINK_AP_AMOUNT
,      PC_LINK_AP_AMOUNT
,      INV_CURRENCY_CODE
,      INVOICE_INV_AMOUNT
,      INVOICE_CURR_PER_INV_AMOUNT
,      AR_INV_RECIEPT_AMOUNT
,      AR_INV_CURR_PER_RECIEPT_AMOUNT
,      AR_OUTSTANDING_AMOUNT
,      AR_INV_ADJUSTMENT_AMOUNT
,      INV_LINE_AMOUNT
,      AR_INV_TAX_AMOUNT
,      PROJFUNC_CURRENCY_CODE
,      PFC_RATE
,      PROJFUNC_BILL_AMOUNT
,      PROJFUNC_CURR_PER_BILL_AMOUNT
,      AR_PFC_RECIEPT_AMOUNT
,      AR_PFC_CURR_PER_RECIEPT_AMOUNT
,      AR_PFC_OUTSTANDING_AMOUNT
,      AR_PFC_ADJUSTMENT_AMOUNT
,      PFC_LINE_AMOUNT
,      AR_PFC_TAX_AMOUNT
,      PROJECT_CURRENCY_CODE
,      PROJ_BILL_AMOUNT
,      PROJ_CURR_PER_BILL_AMOUNT
,      AR_PC_RECIEPT_AMOUNT
,      AR_PC_CURR_PER_RECIEPT_AMOUNT
,      AR_PC_OUTSTANDING_AMOUNT
,      AR_PC_ADJUSTMENT_AMOUNT
,      PC_LINE_AMOUNT
,      AR_PC_TAX_AMOUNT
,      GL_DATE
,      APPROVED_DATE
,      RELEASED_DATE
,      BILL_TO_ADDRESS
,      SHIP_TO_ADDRESS
,      BILL_TO_CUST_NAME
,      SHIP_TO_CUST_NAME
,      BILL_TO_CUST_NUMBER
,      SHIP_TO_CUST_NUMBER
FROM APPS.PA_PWP_CUSTOMER_INVOICE_V;

Dependencies

[top of page]

APPS.PA_PWP_CUSTOMER_INVOICE_V references the following:

SchemaAPPS
SynonymPA_PWP_CUSTOMER_SUMM
ViewPA_PWP_LINK_STATUS_V

APPS.PA_PWP_CUSTOMER_INVOICE_V is not referenced by any database object