[Home] [Help]
94: --
95:
96: select sum(apd.quantity_invoiced)
97: into l_qty_billed
98: from po_distributions_all pod,
99: ap_invoice_distributions_all apd
100: where pod.po_distribution_id = p_po_dist
101: and pod.po_distribution_id = apd.po_distribution_id
102: and NVL(pod.accrue_on_receipt_flag,'N') = 'Y'
194: Select count(*), Sum(nvl(Amount_Ordered,0) + nvl(NonRecoverable_Tax,0) - nvl(Amount_Cancelled,0) -
195: ((nvl(NonRecoverable_Tax,0) * nvl(amount_billed,0) / nvl(amount_ordered,1)) * l_calc_ap_tax)
196: )
197: Into l_PoLineDistCnt, l_PoLineDistCosts
198: From Po_Distributions_All Pod
199: Where Pod.Project_Id = P_Project_Id
200: And Pod.distribution_type <> 'PREPAYMENT'
201: And Pod.Task_Id = P_Task_Id
202: And Pod.Po_Line_Id = P_Po_Line_Id;
855:
856: select nvl(pll.matching_basis, 'QUANTITY') /* modified for bug bug 3496492 */
857: into l_po_line_type
858: from po_lines_all po_line,
859: po_distributions_all po_dist,
860: po_line_locations_all pll
861: where Po_dist.distribution_type <> 'PREPAYMENT'
862: and pll.po_line_id = po_line.po_line_id
863: and po_line.po_line_id = po_dist.po_line_id
1187: select distinct msi.comms_nl_trackable_flag,nvl(pod.accrue_on_receipt_flag,'N')
1188: into l_flag,g_accrue_on_receipt_flag
1189: from
1190: mtl_system_items msi ,
1191: po_distributions_all pod,
1192: po_lines_all pol
1193: where
1194: msi.inventory_item_id=pol.item_id
1195: and pol.po_line_id=pod.po_line_id