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_ALL

Line 101: FROM PO_DISTRIBUTIONS_ALL POD,

97: IF (x_po_header_id IS NOT NULL) THEN
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'

Line 124: FROM PO_DISTRIBUTIONS_ALL POD,

120: ELSE
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'

Line 151: FROM PO_DISTRIBUTIONS_ALL POD,

147: IF (x_po_header_id IS NOT NULL) THEN
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 (+)

Line 175: FROM PO_DISTRIBUTIONS_ALL POD,

171: ELSE
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 (+)

Line 203: FROM PO_DISTRIBUTIONS_ALL POD,

199: IF (x_po_header_id IS NOT NULL) THEN
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 (+)

Line 227: FROM PO_DISTRIBUTIONS_ALL POD,

223: ELSE
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 (+)

Line 255: FROM PO_DISTRIBUTIONS_ALL POD,

251: IF (x_po_header_id IS NOT NULL) THEN
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 (+)

Line 279: FROM PO_DISTRIBUTIONS_ALL POD,

275: ELSE
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 (+)

Line 308: FROM PO_DISTRIBUTIONS_ALL POD,

304: IF (x_po_header_id IS NOT NULL) THEN
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'

Line 331: FROM PO_DISTRIBUTIONS_ALL POD,

327: ELSE
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 (+)

Line 360: FROM PO_DISTRIBUTIONS_ALL POD,

356: IF (x_po_header_id IS NOT NULL) THEN
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 (+)

Line 384: FROM PO_DISTRIBUTIONS_ALL POD,

380: ELSE
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 (+)

Line 414: FROM PO_DISTRIBUTIONS_ALL POD,

410:
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 (+)

Line 432: FROM PO_DISTRIBUTIONS_ALL POD,

428:
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 (+)

Line 453: FROM PO_DISTRIBUTIONS_ALL POD,

449: BEGIN
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 (+)

Line 471: FROM PO_DISTRIBUTIONS_ALL POD,

467:
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 (+)

Line 519: FROM PO_DISTRIBUTIONS_ALL POD,

515: decode(POLL.value_basis, 'RATE',POD.amount_ordered,'FIXED PRICE', POD.amount_ordered,
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

Line 543: FROM PO_DISTRIBUTIONS_ALL POD,

539: decode(POLL.value_basis, 'RATE',POD.amount_ordered,'FIXED PRICE', POD.amount_ordered,
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

Line 592: FROM PO_DISTRIBUTIONS_ALL POD,

588: decode(POLL.value_basis, 'FIXED PRICE', POD.amount_ordered,
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

Line 615: FROM PO_DISTRIBUTIONS_ALL POD,

611: decode(POLL.value_basis, 'FIXED PRICE', POD.amount_ordered,
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