[Home] [Help]
78: , POL.Item_Id
79: , POD.Po_Header_Id
80: , Null
81: , Null )
82: FROM PO_Distributions POD
83: , PO_Lines POL
84: WHERE POD.PO_Distribution_Id = X_PO_Distribution_Id
85: AND POL.PO_Line_Id = POD.PO_Line_Id;
86:
91: , wo.standard_operation_id
92: , wdj.wip_entity_id
93: , wdj.primary_item_id
94: , wo.department_id )
95: FROM PO_Distributions POD
96: , WIP_Discrete_Jobs WDJ
97: , WIP_Operations WO
98: WHERE POD.PO_Distribution_Id = X_PO_Distribution_Id
99: AND WO.WIP_Entity_Id = POD.WIP_Entity_Id
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
240: WHERE DIST.Pa_Addition_Flag IN ( 'N','S','A','B','C','D','E','I',
350: -- AND DIST.Accounting_Date <=
351: -- NVL(l_Trx_Thru_Date, DIST.Accounting_Date)
352: -- AND exists (
353: -- Select 'X'
354: -- from Po_Distributions POD
355: -- , PJM_Org_Parameters POP
356: -- where DIST.Po_Distribution_Id = POD.Po_Distribution_ID
357: -- and POP.Organization_Id = POD.Destination_Organization_Id
358: -- and NVL(POD.Project_Id , POP.Common_Project_Id) =
385: WHERE apd.pa_addition_flag = 'S'
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