DBA Data[Home] [Help]

APPS.PO_TAX_SUMMARY_PKG dependencies on PO_LINES

Line 31: po_lines pol,

27: ((nvl(pod.quantity_ordered,0)-nvl(pod.quantity_cancelled,0))
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

Line 50: po_lines pol,

46: ((nvl(pod.quantity_ordered,0)-nvl(pod.quantity_cancelled,0))
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

Line 69: po_lines pol

65: ((nvl(pod.quantity_ordered,0)-nvl(pod.quantity_cancelled,0))
66: / nvl(pod.quantity_ordered,0)) )), 0)
67: into X_recoverable_tax
68: FROM po_distributions pod,
69: po_lines pol
70: WHERE pod.line_location_id = X_shipment_id
71: AND pod.po_release_id is null -- Bug 3532747
72: AND pod.po_line_id = pol.po_line_id;
73: end if;

Line 84: po_lines pol,

80: ((nvl(pod.quantity_ordered,0)-nvl(pod.quantity_cancelled,0))
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

Line 101: po_lines pol

97: ((nvl(pod.quantity_ordered,0)-nvl(pod.quantity_cancelled,0))
98: / nvl(pod.quantity_ordered,0)) )), 0)
99: into X_recoverable_tax
100: FROM po_distributions pod,
101: po_lines pol
102: WHERE pod.line_location_id = X_shipment_id
103: AND pod.po_line_id = pol.po_line_id;
104: end if;
105: elsif (object_type = 'REQ') then

Line 150: po_lines pol,

146: ((nvl(pod.quantity_ordered,0)-nvl(pod.quantity_cancelled,0))
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

Line 169: po_lines pol,

165: ((nvl(pod.quantity_ordered,0)-nvl(pod.quantity_cancelled,0))
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

Line 188: po_lines pol

184: ((nvl(pod.quantity_ordered,0)-nvl(pod.quantity_cancelled,0))
185: / nvl(pod.quantity_ordered,0)) )), 0)
186: into X_nonrecoverable_tax
187: FROM po_distributions pod,
188: po_lines pol
189: WHERE pod.line_location_id = X_shipment_id
190: AND pod.po_release_id is null -- Bug 3532747
191: AND pod.po_line_id = pol.po_line_id;
192: end if;

Line 203: po_lines pol,

199: ((nvl(pod.quantity_ordered,0)-nvl(pod.quantity_cancelled,0))
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

Line 220: po_lines pol

216: ((nvl(pod.quantity_ordered,0)-nvl(pod.quantity_cancelled,0))
217: / nvl(pod.quantity_ordered,0)) )), 0)
218: into X_nonrecoverable_tax
219: FROM po_distributions pod,
220: po_lines pol
221: WHERE pod.line_location_id = X_shipment_id
222: AND pod.po_line_id = pol.po_line_id;
223: end if;
224: elsif (object_type = 'REQ') then

Line 304: po_lines POL

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';
308:

Line 331: po_lines POL

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';
335:

Line 355: FROM po_lines

351: SELECT nvl(SUM(round(decode(order_type_lookup_code,'RATE',amount,'FIXED PRICE', amount,
352: unit_price * quantity)/X_min_acct_unit)
353: *X_min_acct_unit), 0)
354: into X_header_amount
355: FROM po_lines
356: WHERE po_header_id = X_header_id
357: AND nvl(cancel_flag, 'N') <> 'Y'
358: AND nvl(closed_code, 'OPEN') <> 'FINALLY CLOSED';
359:

Line 364: FROM po_lines

360: else
361: SELECT nvl(SUM(round(decode(order_type_lookup_code,'RATE',amount,'FIXED PRICE', amount,
362: unit_price * quantity), X_precision)), 0)
363: into X_header_amount
364: FROM po_lines
365: WHERE po_header_id = X_header_id
366: AND nvl(cancel_flag, 'N') <> 'Y'
367: AND nvl(closed_code, 'OPEN') <> 'FINALLY CLOSED';
368:

Line 387: po_lines pol

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'
391: AND nvl(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED';

Line 398: po_lines pol

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'
402: AND nvl(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED';

Line 457: -- unique identifier of a line in PO_LINES_ALL

453: -- of the blanket line.
454: --Parameters:
455: --IN:
456: --p_line_id
457: -- unique identifier of a line in PO_LINES_ALL
458: --p_currency_code
459: -- Currency of the document
460: --IN OUT:
461: --OUT:

Line 504: po_lines POL

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');
508:

Line 531: po_lines POL

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');
535: