APPS.PJM_TRANSFER_IPV_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 235: AP_Invoice_Distributions DIST,

231: , POD.Destination_Type_Code Destination_Type_Code
232: , DIST.RCV_Transaction_Id RCV_Transaction_Id
233: FROM
234: AP_Invoices INV,
235: AP_Invoice_Distributions DIST,
236: PO_Distributions POD,
237: PO_Lines POL,
238: PA_Projects_ALL PAP,
239: PJM_Org_Parameters POP

Line 334: -- UPDATE /*+ index(DIST AP_INVOICE_DISTRIBUTIONS_N14) */

330: PJM_CONC.put_line(fnd_message.get || ' ...');
331:
332: l_progress := 20;
333:
334: -- UPDATE /*+ index(DIST AP_INVOICE_DISTRIBUTIONS_N14) */
335: -- AP_Invoice_Distributions DIST
336: -- SET DIST.Pa_Addition_Flag = 'S'
337: -- , DIST.Request_Id = l_request_id
338: -- , DIST.Last_Update_Date = SYSDATE

Line 335: -- AP_Invoice_Distributions DIST

331:
332: l_progress := 20;
333:
334: -- UPDATE /*+ index(DIST AP_INVOICE_DISTRIBUTIONS_N14) */
335: -- AP_Invoice_Distributions DIST
336: -- SET DIST.Pa_Addition_Flag = 'S'
337: -- , DIST.Request_Id = l_request_id
338: -- , DIST.Last_Update_Date = SYSDATE
339: -- , DIST.Last_Updated_By = l_user_id

Line 383: UPDATE ap_invoice_distributions apd

379: ----------------------------------------------------------------------
380: /* Bug 3495426 has taken care of the reversed transactions.
381: Net Zero is no longer needed.
382:
383: UPDATE ap_invoice_distributions apd
384: SET apd.pa_addition_flag = 'Z'
385: WHERE apd.pa_addition_flag = 'S'
386: AND apd.request_id = l_request_id
387: AND 0 = (

Line 390: , ap_invoice_distributions apd2

386: AND apd.request_id = l_request_id
387: AND 0 = (
388: SELECT SUM( nvl(apd2.base_amount , apd2.amount) )
389: FROM po_distributions pod
390: , ap_invoice_distributions apd2
391: WHERE pod.po_distribution_id = apd.po_distribution_id
392: AND apd2.po_distribution_id = pod.po_distribution_id
393: AND apd2.pa_addition_flag = apd.pa_addition_flag
394: AND apd2.request_id = apd.request_id

Line 634: AP_Invoice_Distributions DIST

630: , l_user_id
631: , SYSDATE
632: , l_user_id
633: FROM
634: AP_Invoice_Distributions DIST
635: , PA_Tasks TASK
636: , HR_Organization_Units ORG
637: WHERE
638: DIST.Invoice_Id = InvRec.Invoice_Id

Line 741: AP_Invoice_Distributions DIST

737: , l_user_id
738: , SYSDATE
739: , l_user_id
740: FROM
741: AP_Invoice_Distributions DIST
742: , PA_Tasks TASK
743: , HR_Organization_Units ORG
744: WHERE
745: DIST.Invoice_Id = InvRec.Invoice_Id

Line 769: UPDATE AP_Invoice_Distributions

765: PJM_CONC.new_line(1);
766:
767: l_progress := 130;
768:
769: UPDATE AP_Invoice_Distributions
770: SET Pa_Addition_Flag = 'Y',
771: Request_Id = l_request_id
772: WHERE -- Pa_Addition_Flag = 'S' AND
773: Invoice_Id = InvRec.Invoice_Id