DBA Data[Home] [Help]

APPS.PA_INV_ON_ACCOUNT_CM dependencies on PA_DRAFT_INVOICE_ITEMS

Line 30: pa_draft_invoice_items pdii_cm,

26: pa_draft_invoices pdi_cm,
27: pa_implementations pi,
28: pa_projects pa,
29: ra_batch_sources rbs,
30: pa_draft_invoice_items pdii_cm,
31: ra_customer_trx rct,
32: ra_cust_trx_types rctt
33: WHERE pdi_cm.project_id = pdi.project_id
34: AND pdi_cm.draft_invoice_num_credited = pdi.draft_invoice_num

Line 60: FROM pa_draft_invoice_items pdii

56: SELECT pdii.project_id,
57: pdii.line_num,
58: pdii.draft_inv_line_num_credited line_num_credited,
59: pdii.inv_amount
60: FROM pa_draft_invoice_items pdii
61: WHERE pdii.project_id = c_project_id
62: AND pdii.draft_invoice_num = c_draft_invoice_num
63: AND inv_amount <> 0 ;
64: