[Home] [Help]
97: --
98:
99: select sum(apd.quantity_invoiced)
100: into l_qty_billed
101: from po_distributions_all pod,
102: ap_invoice_distributions_all apd
103: where pod.po_distribution_id = p_po_dist
104: and pod.po_distribution_id = apd.po_distribution_id
105: and NVL(pod.accrue_on_receipt_flag,'N') = 'Y'
109:
110: -- Bug 13602288: Added below select query as a part of self assessed tax enhancement
111: select sum(sat.quantity_invoiced)
112: into l_qty_billed2
113: from po_distributions_all pod,
114: ap_self_assessed_tax_dist_all sat
115: where pod.po_distribution_id = p_po_dist
116: and pod.po_distribution_id = sat.po_distribution_id
117: and NVL(pod.accrue_on_receipt_flag,'N') = 'Y'
209: Select count(*), Sum(nvl(Amount_Ordered,0) + nvl(NonRecoverable_Tax,0) - nvl(Amount_Cancelled,0) -
210: ((nvl(NonRecoverable_Tax,0) * nvl(amount_billed,0) / nvl(amount_ordered,1)) * l_calc_ap_tax)
211: )
212: Into l_PoLineDistCnt, l_PoLineDistCosts
213: From Po_Distributions_All Pod
214: Where Pod.Project_Id = P_Project_Id
215: And Pod.distribution_type <> 'PREPAYMENT'
216: And Pod.Task_Id = P_Task_Id
217: And Pod.Po_Line_Id = P_Po_Line_Id;
966:
967: select nvl(pll.matching_basis, 'QUANTITY') /* modified for bug bug 3496492 */
968: into l_po_line_type
969: from po_lines_all po_line,
970: po_distributions_all po_dist,
971: po_line_locations_all pll
972: where Po_dist.distribution_type <> 'PREPAYMENT'
973: and pll.po_line_id = po_line.po_line_id
974: and po_line.po_line_id = po_dist.po_line_id
1298: select distinct msi.comms_nl_trackable_flag,nvl(pod.accrue_on_receipt_flag,'N')
1299: into l_flag,g_accrue_on_receipt_flag
1300: from
1301: mtl_system_items msi ,
1302: po_distributions_all pod,
1303: po_lines_all pol
1304: where
1305: msi.inventory_item_id=pol.item_id
1306: and pol.po_line_id=pod.po_line_id