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_CHORD_WF4 dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 102: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

98: BEGIN
99: SELECT DISTINCT 'Y'
100: INTO x_dist_control.distribution_num
101: FROM PO_DISTRIBUTIONS_ALL POD,
102: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
103: WHERE POD.po_header_id = x_po_header_id
104: AND POD.po_distribution_id = PODA.po_distribution_id (+)
105: AND PODA.latest_external_flag (+) = 'Y'
106: AND (

Line 125: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

121: BEGIN
122: SELECT DISTINCT 'Y'
123: INTO x_dist_control.distribution_num
124: FROM PO_DISTRIBUTIONS_ALL POD,
125: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
126: WHERE POD.po_release_id = x_po_release_id
127: AND POD.po_distribution_id = PODA.po_distribution_id (+)
128: AND PODA.latest_external_flag (+) = 'Y'
129: AND (

Line 152: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

148: BEGIN
149: SELECT DISTINCT 'Y'
150: INTO x_dist_control.deliver_to_person_id
151: FROM PO_DISTRIBUTIONS_ALL POD,
152: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
153: WHERE
154: POD.po_header_id = x_po_header_id
155: AND POD.po_distribution_id = PODA.po_distribution_id (+)
156: AND PODA.latest_external_flag (+) = 'Y'

Line 176: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

172: BEGIN
173: SELECT DISTINCT 'Y'
174: INTO x_dist_control.deliver_to_person_id
175: FROM PO_DISTRIBUTIONS_ALL POD,
176: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
177: WHERE
178: POD.po_release_id = x_po_release_id
179: AND POD.po_distribution_id = PODA.po_distribution_id (+)
180: AND PODA.latest_external_flag (+) = 'Y'

Line 204: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

200: BEGIN
201: SELECT DISTINCT 'Y'
202: INTO x_dist_control.rate_date
203: FROM PO_DISTRIBUTIONS_ALL POD,
204: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
205: WHERE
206: POD.po_header_id = x_po_header_id
207: AND POD.po_distribution_id = PODA.po_distribution_id (+)
208: AND PODA.latest_external_flag (+) = 'Y'

Line 228: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

224: BEGIN
225: SELECT DISTINCT 'Y'
226: INTO x_dist_control.rate_date
227: FROM PO_DISTRIBUTIONS_ALL POD,
228: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
229: WHERE
230: POD.po_release_id = x_po_release_id
231: AND POD.po_distribution_id = PODA.po_distribution_id (+)
232: AND PODA.latest_external_flag (+) = 'Y'

Line 256: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

252: BEGIN
253: SELECT DISTINCT 'Y'
254: INTO x_dist_control.gl_encumbered_date
255: FROM PO_DISTRIBUTIONS_ALL POD,
256: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
257: WHERE
258: POD.po_header_id = x_po_header_id
259: AND POD.po_distribution_id = PODA.po_distribution_id (+)
260: AND PODA.latest_external_flag (+) = 'Y'

Line 280: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

276: BEGIN
277: SELECT DISTINCT 'Y'
278: INTO x_dist_control.gl_encumbered_date
279: FROM PO_DISTRIBUTIONS_ALL POD,
280: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
281: WHERE
282: POD.po_release_id = x_po_release_id
283: AND POD.po_distribution_id = PODA.po_distribution_id (+)
284: AND PODA.latest_external_flag (+) = 'Y'

Line 309: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

305: BEGIN
306: SELECT DISTINCT 'Y'
307: INTO x_dist_control.code_combination_id
308: FROM PO_DISTRIBUTIONS_ALL POD,
309: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
310: WHERE POD.po_header_id = x_po_header_id
311: AND POD.po_distribution_id = PODA.po_distribution_id (+)
312: AND PODA.latest_external_flag (+) = 'Y'
313: AND (

Line 332: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

328: BEGIN
329: SELECT DISTINCT 'Y'
330: INTO x_dist_control.code_combination_id
331: FROM PO_DISTRIBUTIONS_ALL POD,
332: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
333: WHERE
334: POD.po_release_id = x_po_release_id
335: AND POD.po_distribution_id = PODA.po_distribution_id (+)
336: AND PODA.latest_external_flag (+) = 'Y'

Line 361: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

357: BEGIN
358: SELECT DISTINCT 'Y'
359: INTO x_dist_control.destination_subinventory
360: FROM PO_DISTRIBUTIONS_ALL POD,
361: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
362: WHERE
363: POD.po_header_id = x_po_header_id
364: AND POD.po_distribution_id = PODA.po_distribution_id (+)
365: AND PODA.latest_external_flag (+) = 'Y'

Line 385: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

381: BEGIN
382: SELECT DISTINCT 'Y'
383: INTO x_dist_control.destination_subinventory
384: FROM PO_DISTRIBUTIONS_ALL POD,
385: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
386: WHERE
387: POD.po_release_id = x_po_release_id
388: AND POD.po_distribution_id = PODA.po_distribution_id (+)
389: AND PODA.latest_external_flag (+) = 'Y'

Line 415: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

411: SELECT max(po_chord_wf0.percentage_change(
412: PODA.quantity_ordered, POD.quantity_ordered))
413: INTO x_dist_control.quantity_ordered_change
414: FROM PO_DISTRIBUTIONS_ALL POD,
415: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
416: WHERE
417: POD.po_header_id = x_po_header_id
418: AND POD.po_distribution_id = PODA.po_distribution_id (+)
419: AND PODA.latest_external_flag (+) = 'Y'

Line 433: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

429: SELECT max(po_chord_wf0.percentage_change(
430: PODA.quantity_ordered, POD.quantity_ordered))
431: INTO x_dist_control.quantity_ordered_change
432: FROM PO_DISTRIBUTIONS_ALL POD,
433: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
434: WHERE
435: POD.po_release_id = x_po_release_id
436: AND POD.po_distribution_id = PODA.po_distribution_id (+)
437: AND PODA.latest_external_flag (+) = 'Y';

Line 454: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

450: SELECT max(po_chord_wf0.percentage_change(
451: PODA.rate, POD.rate))
452: INTO x_dist_control.rate_change
453: FROM PO_DISTRIBUTIONS_ALL POD,
454: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
455: WHERE
456: POD.po_header_id = x_po_header_id
457: AND POD.po_distribution_id = PODA.po_distribution_id (+)
458: AND PODA.latest_external_flag (+) = 'Y'

Line 472: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

468: SELECT max(po_chord_wf0.percentage_change(
469: PODA.rate, POD.rate))
470: INTO x_dist_control.rate_change
471: FROM PO_DISTRIBUTIONS_ALL POD,
472: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
473: WHERE
474: POD.po_release_id = x_po_release_id
475: AND POD.po_distribution_id = PODA.po_distribution_id (+)
476: AND PODA.latest_external_flag (+) = 'Y';

Line 520: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,

516: (POD.quantity_ordered*POLL.price_override)) / l_min_acct_unit )* l_min_acct_unit
517: ))
518: INTO x_dist_control.amount_ordered_change
519: FROM PO_DISTRIBUTIONS_ALL POD,
520: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,
521: PO_LINE_LOCATIONS_ALL POLL,
522: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
523: WHERE POD.po_header_id = x_po_header_id
524: AND POD.po_distribution_id = PODA.po_distribution_id (+)

Line 544: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,

540: (POD.quantity_ordered*POLL.price_override)) , l_precision )
541: ))
542: INTO x_dist_control.amount_ordered_change
543: FROM PO_DISTRIBUTIONS_ALL POD,
544: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,
545: PO_LINE_LOCATIONS_ALL POLL,
546: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
547: WHERE POD.po_header_id = x_po_header_id
548: AND POD.po_distribution_id = PODA.po_distribution_id (+)

Line 593: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,

589: (POD.quantity_ordered*POLL.price_override)) / l_min_acct_unit )* l_min_acct_unit
590: ))
591: INTO x_dist_control.amount_ordered_change
592: FROM PO_DISTRIBUTIONS_ALL POD,
593: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,
594: PO_LINE_LOCATIONS_ALL POLL,
595: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
596: WHERE POD.po_release_id = x_po_release_id
597: AND POD.po_distribution_id = PODA.po_distribution_id (+)

Line 616: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,

612: (POD.quantity_ordered*POLL.price_override)) , l_precision )
613: ))
614: INTO x_dist_control.amount_ordered_change
615: FROM PO_DISTRIBUTIONS_ALL POD,
616: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,
617: PO_LINE_LOCATIONS_ALL POLL,
618: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
619: WHERE POD.po_release_id = x_po_release_id
620: AND POD.po_distribution_id = PODA.po_distribution_id (+)