DBA Data[Home] [Help]

APPS.PA_PWP_SUMM_PKG dependencies on PA_CUSTOMERS_V

Line 103: , PA_CUSTOMERS_V C

99: , l_user_id
100: , l_date
101: FROM PA_DRAFT_INVOICES_ALL I
102: , PA_DRAFT_INVOICES_ALL ORG_INV
103: , PA_CUSTOMERS_V C
104: ,PA_LOOKUPS LK
105: ,PA_AGREEMENTS_ALL A
106: WHERE I.AGREEMENT_ID = A.AGREEMENT_ID
107: and I.PROJECT_ID = P_Project_Id

Line 408: pa_customers_v bill_c,

404: ship_c.customer_number,
405: ship_c.customer_name
406: from
407: pa_draft_invoices_all pda,
408: pa_customers_v bill_c,
409: pa_customers_v ship_c
410:
411: where
412: bill_c.customer_id (+) = pda.bill_to_customer_id

Line 409: pa_customers_v ship_c

405: ship_c.customer_name
406: from
407: pa_draft_invoices_all pda,
408: pa_customers_v bill_c,
409: pa_customers_v ship_c
410:
411: where
412: bill_c.customer_id (+) = pda.bill_to_customer_id
413: AND ship_c.customer_id (+) = pda.ship_to_customer_id