[Home] [Help]
28: / nvl(pod.quantity_ordered,0)) )), 0)
29: into X_recoverable_tax
30: FROM po_distributions pod,
31: po_lines pol,
32: po_line_locations pll
33: WHERE pod.po_header_id = X_header_id
34: AND pll.po_line_id = pol.po_line_id
35: AND pll.line_location_id = pod.line_location_id
36: AND pod.po_release_id is null -- Bug 3532747
47: / nvl(pod.quantity_ordered,0)) )), 0)
48: into X_recoverable_tax
49: FROM po_distributions pod,
50: po_lines pol,
51: po_line_locations pll
52: WHERE pod.po_line_id = X_line_id
53: AND pll.po_line_id = pol.po_line_id
54: AND pll.line_location_id = pod.line_location_id
55: AND pod.po_release_id is null -- Bug 3532747
81: / nvl(pod.quantity_ordered,0)) )), 0)
82: into X_recoverable_tax
83: FROM po_distributions pod,
84: po_lines pol,
85: po_line_locations pll
86: WHERE pod.po_release_id = X_header_id
87: AND pll.line_location_id = pod.line_location_id
88: AND pll.po_line_id = pol.po_line_id
89: AND (nvl(pll.quantity,0)-nvl(pll.quantity_cancelled,0) <> 0 OR
147: / nvl(pod.quantity_ordered,0)) )), 0)
148: into X_nonrecoverable_tax
149: FROM po_distributions pod,
150: po_lines pol,
151: po_line_locations pll
152: WHERE pod.po_header_id = X_header_id
153: AND pll.po_line_id = pol.po_line_id
154: AND pll.line_location_id = pod.line_location_id
155: AND pod.po_release_id is null -- Bug 3532747
166: / nvl(pod.quantity_ordered,0)) )), 0)
167: into X_nonrecoverable_tax
168: FROM po_distributions pod,
169: po_lines pol,
170: po_line_locations pll
171: WHERE pod.po_line_id = X_line_id
172: AND pll.po_line_id = pol.po_line_id
173: AND pll.line_location_id = pod.line_location_id
174: AND pod.po_release_id is null -- Bug 3532747
200: / nvl(pod.quantity_ordered,0)) )), 0)
201: into X_nonrecoverable_tax
202: FROM po_distributions pod,
203: po_lines pol,
204: po_line_locations pll
205: WHERE pod.po_release_id = X_header_id
206: AND pll.po_line_id = pol.po_line_id
207: AND pll.line_location_id = pod.line_location_id
208: AND (nvl(pll.quantity,0)-nvl(pll.quantity_cancelled,0) <> 0 OR
299: ) * x_min_acct_unit
300: ), 0
301: )
302: INTO x_header_amount
303: FROM po_line_locations PLL,
304: po_lines POL
305: WHERE PLL.po_line_id = POL.po_line_id
306: AND POL.po_header_id = x_header_id
307: AND PLL.shipment_type = 'BLANKET';
326: )
327: ), 0
328: )
329: INTO x_header_amount
330: FROM po_line_locations PLL,
331: po_lines POL
332: WHERE PLL.po_line_id = POL.po_line_id
333: AND POL.po_header_id = x_header_id
334: AND PLL.shipment_type = 'BLANKET';
382: SELECT nvl(SUM(round(decode(pol.order_type_lookup_code,'FIXED PRICE',pll.amount,
383: pll.price_override * pll.quantity)/X_min_acct_unit)
384: *X_min_acct_unit), 0) -- SERVICES FPJ
385: into X_header_amount
386: FROM po_line_locations pll,
387: po_lines pol
388: WHERE pll.po_release_id = X_header_id
389: AND pol.po_line_id = pll.po_line_id
390: AND nvl(pll.cancel_flag, 'N') <> 'Y'
393: else
394: SELECT nvl(SUM(round(decode(pol.order_type_lookup_code,'FIXED PRICE',pll.amount,
395: pll.price_override * pll.quantity),X_precision)), 0) -- SERVICES FPJ
396: into X_header_amount
397: FROM po_line_locations pll,
398: po_lines pol
399: WHERE pll.po_release_id = X_header_id
400: AND pol.po_line_id = pll.po_line_id
401: AND nvl(pll.cancel_flag, 'N') <> 'Y'
499: ) * l_min_acct_unit
500: ), 0
501: )
502: INTO l_line_amount
503: FROM po_line_locations PLL,
504: po_lines POL
505: WHERE PLL.po_line_id = POL.po_line_id
506: AND POL.po_line_id = p_line_id
507: AND PLL.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET');
526: )
527: ), 0
528: )
529: INTO l_line_amount
530: FROM po_line_locations PLL,
531: po_lines POL
532: WHERE PLL.po_line_id = POL.po_line_id
533: AND POL.po_line_id = p_line_id
534: AND PLL.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET');