eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_TAX_SUMMARY_PKG dependencies on PO_DISTRIBUTIONS

Line 30: FROM po_distributions pod,

26: ((nvl(pod.amount_ordered,0) - nvl(pod.amount_cancelled,0))/nvl(pod.amount_ordered,0)),
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

Line 49: FROM po_distributions pod,

45: ((nvl(pod.amount_ordered,0) - nvl(pod.amount_cancelled,0))/nvl(pod.amount_ordered,0)),
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

Line 68: FROM po_distributions pod,

64: ((nvl(pod.amount_ordered,0) - nvl(pod.amount_cancelled,0))/nvl(pod.amount_ordered,0)),
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;

Line 83: FROM po_distributions pod,

79: ((nvl(pod.amount_ordered,0) - nvl(pod.amount_cancelled,0))/nvl(pod.amount_ordered,0)),
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

Line 100: FROM po_distributions pod,

96: ((nvl(pod.amount_ordered,0) - nvl(pod.amount_cancelled,0))/nvl(pod.amount_ordered,0)),
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;

Line 149: FROM po_distributions pod,

145: ((nvl(pod.amount_ordered,0) - nvl(pod.amount_cancelled,0))/nvl(pod.amount_ordered,0)),
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

Line 168: FROM po_distributions pod,

164: ((nvl(pod.amount_ordered,0) - nvl(pod.amount_cancelled,0))/nvl(pod.amount_ordered,0)),
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

Line 187: FROM po_distributions pod,

183: ((nvl(pod.amount_ordered,0) - nvl(pod.amount_cancelled,0))/nvl(pod.amount_ordered,0)),
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;

Line 202: FROM po_distributions pod,

198: ((nvl(pod.amount_ordered,0) - nvl(pod.amount_cancelled,0))/nvl(pod.amount_ordered,0)),
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

Line 219: FROM po_distributions pod,

215: ((nvl(pod.amount_ordered,0) - nvl(pod.amount_cancelled,0))/nvl(pod.amount_ordered,0)),
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;