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_WF3 dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 130: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

126: BEGIN
127: SELECT DISTINCT 'Y'
128: INTO x_shipments_control.shipment_num
129: FROM PO_LINE_LOCATIONS_ALL POLL,
130: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
131: WHERE
132: POLL.po_header_id = x_po_header_id
133: AND POLL.line_location_id = POLLA.line_location_id (+)
134: AND POLLA.latest_external_flag (+) = 'Y'

Line 152: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

148: BEGIN
149: SELECT DISTINCT 'Y'
150: INTO x_shipments_control.shipment_num
151: FROM PO_LINE_LOCATIONS_ALL POLL,
152: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
153: WHERE
154: POLL.po_release_id = x_po_release_id
155: AND POLL.line_location_id = POLLA.line_location_id (+)
156: AND POLLA.latest_external_flag (+) = 'Y'

Line 178: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

174: BEGIN
175: SELECT DISTINCT 'Y'
176: INTO x_shipments_control.ship_to_organization_id
177: FROM PO_LINE_LOCATIONS_ALL POLL,
178: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
179: WHERE
180: POLL.po_header_id = x_po_header_id
181: AND POLL.line_location_id = POLLA.line_location_id (+)
182: AND POLLA.latest_external_flag (+) = 'Y'

Line 202: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

198: BEGIN
199: SELECT DISTINCT 'Y'
200: INTO x_shipments_control.ship_to_organization_id
201: FROM PO_LINE_LOCATIONS_ALL POLL,
202: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
203: WHERE
204: POLL.po_release_id = x_po_release_id
205: AND POLL.line_location_id = POLLA.line_location_id (+)
206: AND POLLA.latest_external_flag (+) = 'Y'

Line 230: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

226: BEGIN
227: SELECT DISTINCT 'Y'
228: INTO x_shipments_control.ship_to_location_id
229: FROM PO_LINE_LOCATIONS_ALL POLL,
230: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
231: WHERE
232: POLL.po_header_id = x_po_header_id
233: AND POLL.line_location_id = POLLA.line_location_id (+)
234: AND POLLA.latest_external_flag (+) = 'Y'

Line 253: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

249: BEGIN
250: SELECT DISTINCT 'Y'
251: INTO x_shipments_control.ship_to_location_id
252: FROM PO_LINE_LOCATIONS_ALL POLL,
253: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
254: WHERE
255: POLL.po_release_id = x_po_release_id
256: AND POLL.line_location_id = POLLA.line_location_id (+)
257: AND POLLA.latest_external_flag (+) = 'Y'

Line 282: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

278: -- Sql What : determine if promised date changed
279: SELECT DISTINCT 'Y'
280: INTO x_shipments_control.promised_date
281: FROM PO_LINE_LOCATIONS_ALL POLL,
282: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
283: WHERE
284: POLL.po_header_id = x_po_header_id
285: AND POLL.line_location_id = POLLA.line_location_id (+)
286: AND POLLA.latest_external_flag (+) = 'Y'

Line 301: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

297: -- Sql What : retrieve the change in promised date
298: SELECT max(trunc(POLL.promised_date-POLLA.promised_date))
299: INTO x_shipments_control.promised_date_change
300: FROM PO_LINE_LOCATIONS_ALL POLL,
301: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
302: WHERE POLL.po_header_id = x_po_header_id
303: AND POLL.line_location_id = POLLA.line_location_id (+)
304: AND POLLA.latest_external_flag (+) = 'Y'
305: AND poll.po_release_id is NULL

Line 318: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

314: -- Sql What : determine if promised date changed
315: SELECT DISTINCT 'Y'
316: INTO x_shipments_control.promised_date
317: FROM PO_LINE_LOCATIONS_ALL POLL,
318: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
319: WHERE
320: POLL.po_release_id = x_po_release_id
321: AND POLL.line_location_id = POLLA.line_location_id (+)
322: AND POLLA.latest_external_flag (+) = 'Y'

Line 336: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

332: -- Sql What : retrieve the change in promised date
333: SELECT max(trunc(POLL.promised_date-POLLA.promised_date))
334: INTO x_shipments_control.promised_date_change
335: FROM PO_LINE_LOCATIONS_ALL POLL,
336: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
337: WHERE POLL.po_release_id = x_po_release_id
338: AND POLL.line_location_id = POLLA.line_location_id (+)
339: AND POLLA.latest_external_flag (+) = 'Y'
340: AND (POLL.promised_date IS NOT NULL OR POLLA.promised_date IS NOT NULL);

Line 355: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

351: -- Sql What : determine if need by date changed
352: SELECT DISTINCT 'Y'
353: INTO x_shipments_control.need_by_date
354: FROM PO_LINE_LOCATIONS_ALL POLL,
355: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
356: WHERE
357: POLL.po_header_id = x_po_header_id
358: AND POLL.line_location_id = POLLA.line_location_id (+)
359: AND POLLA.latest_external_flag (+) = 'Y'

Line 374: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

370: -- Sql What : retrieve the change in need by date
371: SELECT max(trunc(POLL.need_by_date-POLLA.need_by_date))
372: INTO x_shipments_control.need_by_date_change
373: FROM PO_LINE_LOCATIONS_ALL POLL,
374: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
375: WHERE POLL.po_header_id = x_po_header_id
376: AND POLL.line_location_id = POLLA.line_location_id (+)
377: AND POLLA.latest_external_flag (+) = 'Y'
378: AND poll.po_release_id is NULL -- Bug 4016493 : Ignore release shipments

Line 391: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

387: -- Sql What : determine if need by date changed
388: SELECT DISTINCT 'Y'
389: INTO x_shipments_control.need_by_date
390: FROM PO_LINE_LOCATIONS_ALL POLL,
391: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
392: WHERE
393: POLL.po_release_id = x_po_release_id
394: AND POLL.line_location_id = POLLA.line_location_id (+)
395: AND POLLA.latest_external_flag (+) = 'Y'

Line 409: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

405: -- Sql What : retrieve the change in need by date
406: SELECT max(trunc(POLL.need_by_date-POLLA.need_by_date))
407: INTO x_shipments_control.need_by_date_change
408: FROM PO_LINE_LOCATIONS_ALL POLL,
409: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
410: WHERE POLL.po_release_id = x_po_release_id
411: AND POLL.line_location_id = POLLA.line_location_id (+)
412: AND POLLA.latest_external_flag (+) = 'Y'
413: AND (POLL.need_by_date IS NOT NULL OR POLLA.need_by_date IS NOT NULL);

Line 431: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

427: BEGIN
428: SELECT DISTINCT 'Y'
429: INTO x_shipments_control.last_accept_date
430: FROM PO_LINE_LOCATIONS_ALL POLL,
431: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
432: WHERE
433: POLL.po_header_id = x_po_header_id
434: AND POLL.line_location_id = POLLA.line_location_id (+)
435: AND POLLA.latest_external_flag (+) = 'Y'

Line 453: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

449: BEGIN
450: SELECT DISTINCT 'Y'
451: INTO x_shipments_control.last_accept_date
452: FROM PO_LINE_LOCATIONS_ALL POLL,
453: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
454: WHERE
455: POLL.po_release_id = x_po_release_id
456: AND POLL.line_location_id = POLLA.line_location_id (+)
457: AND POLLA.latest_external_flag (+) = 'Y'

Line 480: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

476: BEGIN
477: SELECT DISTINCT 'Y'
478: INTO x_shipments_control.taxable_flag
479: FROM PO_LINE_LOCATIONS_ALL POLL,
480: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
481: WHERE
482: POLL.po_header_id = x_po_header_id
483: AND POLL.line_location_id = POLLA.line_location_id (+)
484: AND POLLA.latest_external_flag (+) = 'Y'

Line 501: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

497: BEGIN
498: SELECT DISTINCT 'Y'
499: INTO x_shipments_control.taxable_flag
500: FROM PO_LINE_LOCATIONS_ALL POLL,
501: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
502: WHERE
503: POLL.po_release_id = x_po_release_id
504: AND POLL.line_location_id = POLLA.line_location_id (+)
505: AND POLLA.latest_external_flag (+) = 'Y'

Line 527: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

523: BEGIN
524: SELECT DISTINCT 'Y'
525: INTO x_shipments_control.cancel_flag
526: FROM PO_LINE_LOCATIONS_ALL POLL,
527: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
528: WHERE
529: POLL.po_header_id = x_po_header_id
530: AND POLL.line_location_id = POLLA.line_location_id (+)
531: AND POLLA.latest_external_flag (+) = 'Y'

Line 548: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

544: BEGIN
545: SELECT DISTINCT 'Y'
546: INTO x_shipments_control.cancel_flag
547: FROM PO_LINE_LOCATIONS_ALL POLL,
548: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
549: WHERE
550: POLL.po_release_id = x_po_release_id
551: AND POLL.line_location_id = POLLA.line_location_id (+)
552: AND POLLA.latest_external_flag (+) = 'Y'

Line 574: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

570: BEGIN
571: SELECT DISTINCT 'Y'
572: INTO x_shipments_control.closed_code
573: FROM PO_LINE_LOCATIONS_ALL POLL,
574: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
575: WHERE
576: POLL.po_header_id = x_po_header_id
577: AND POLL.line_location_id = POLLA.line_location_id (+)
578: AND POLLA.latest_external_flag (+) = 'Y'

Line 596: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

592: BEGIN
593: SELECT DISTINCT 'Y'
594: INTO x_shipments_control.closed_code
595: FROM PO_LINE_LOCATIONS_ALL POLL,
596: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
597: WHERE
598: POLL.po_release_id = x_po_release_id
599: AND POLL.line_location_id = POLLA.line_location_id (+)
600: AND POLLA.latest_external_flag (+) = 'Y'

Line 624: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

620: BEGIN
621: SELECT max(trunc(POLL.start_date-POLLA.start_date))
622: INTO x_shipments_control.start_date_change
623: FROM PO_LINE_LOCATIONS_ALL POLL,
624: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
625: WHERE POLL.po_header_id = x_po_header_id
626: AND POLL.line_location_id = POLLA.line_location_id (+)
627: AND POLLA.latest_external_flag (+) = 'Y'
628: AND poll.po_release_id is NULL; -- Bug 4016493 : Ignore release shipments

Line 638: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

634: BEGIN
635: SELECT max(trunc(POLL.start_date-POLLA.start_date))
636: INTO x_shipments_control.start_date_change
637: FROM PO_LINE_LOCATIONS_ALL POLL,
638: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
639: WHERE POLL.po_release_id = x_po_release_id
640: AND POLL.line_location_id = POLLA.line_location_id (+)
641: AND POLLA.latest_external_flag (+) = 'Y';
642: EXCEPTION

Line 663: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

659: BEGIN
660: SELECT max(trunc(POLL.end_date-POLLA.end_date))
661: INTO x_shipments_control.end_date_change
662: FROM PO_LINE_LOCATIONS_ALL POLL,
663: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
664: WHERE POLL.po_header_id = x_po_header_id
665: AND POLL.line_location_id = POLLA.line_location_id (+)
666: AND POLLA.latest_external_flag (+) = 'Y'
667: AND poll.po_release_id is NULL; -- Bug 4016493 : Ignore release shipments

Line 677: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

673: BEGIN
674: SELECT max(trunc(POLL.end_date-POLLA.end_date))
675: INTO x_shipments_control.end_date_change
676: FROM PO_LINE_LOCATIONS_ALL POLL,
677: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
678: WHERE POLL.po_release_id = x_po_release_id
679: AND POLL.line_location_id = POLLA.line_location_id (+)
680: AND POLLA.latest_external_flag (+) = 'Y';
681: EXCEPTION

Line 703: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

699:
700: SELECT DISTINCT 'Y'
701: INTO x_shipments_control.payment_type
702: FROM PO_LINE_LOCATIONS_ALL POLL,
703: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
704: WHERE POLL.po_header_id = x_po_header_id
705: AND NVL(POLL.payment_type, 'NONE') NOT IN ('DELIVERY', 'ADVANCE')
706: AND POLL.line_location_id = POLLA.line_location_id (+)
707: AND POLLA.latest_external_flag (+) = 'Y'

Line 726: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

722:
723: SELECT DISTINCT 'Y'
724: INTO x_shipments_control.description
725: FROM PO_LINE_LOCATIONS_ALL POLL,
726: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
727: WHERE POLL.po_header_id = x_po_header_id
728: AND NVL(POLL.payment_type, 'NONE') NOT IN ('DELIVERY', 'ADVANCE')
729: AND POLL.line_location_id = POLLA.line_location_id (+)
730: AND POLLA.latest_external_flag (+) = 'Y'

Line 749: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

745:
746: SELECT DISTINCT 'Y'
747: INTO x_shipments_control.work_approver_id
748: FROM PO_LINE_LOCATIONS_ALL POLL,
749: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
750: WHERE POLL.po_header_id = x_po_header_id
751: AND NVL(POLL.payment_type, 'NONE') NOT IN ('DELIVERY', 'ADVANCE')
752: AND POLL.line_location_id = POLLA.line_location_id (+)
753: AND POLLA.latest_external_flag (+) = 'Y'

Line 786: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

782: BEGIN
783: SELECT DISTINCT 'Y'
784: INTO x_shipments_control.price_override
785: FROM PO_LINE_LOCATIONS_ALL POLL,
786: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
787: WHERE
788: POLL.po_header_id = x_po_header_id
789: AND NVL(POLL.payment_type, 'NONE') <> 'DELIVERY' --
790: AND POLL.line_location_id = POLLA.line_location_id (+)

Line 809: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

805: BEGIN
806: SELECT DISTINCT 'Y'
807: INTO x_shipments_control.price_override
808: FROM PO_LINE_LOCATIONS_ALL POLL,
809: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
810: WHERE
811: POLL.po_release_id = x_po_release_id
812: AND POLL.line_location_id = POLLA.line_location_id (+)
813: AND POLLA.latest_external_flag (+) = 'Y'

Line 837: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

833: SELECT max(po_chord_wf0.percentage_change(
834: POLLA.quantity, POLL.quantity))
835: INTO x_shipments_control.quantity_change
836: FROM PO_LINE_LOCATIONS_ALL POLL,
837: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
838: WHERE POLL.po_header_id = x_po_header_id
839: AND NVL(POLL.payment_type, 'NONE') <> 'DELIVERY' --
840: AND POLL.line_location_id = POLLA.line_location_id (+)
841: AND POLLA.latest_external_flag (+) = 'Y'

Line 853: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

849: SELECT max(po_chord_wf0.percentage_change(
850: POLLA.quantity, POLL.quantity))
851: INTO x_shipments_control.quantity_change
852: FROM PO_LINE_LOCATIONS_ALL POLL,
853: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
854: WHERE
855: POLL.po_release_id = x_po_release_id
856: AND POLL.line_location_id = POLLA.line_location_id (+)
857: AND POLLA.latest_external_flag (+) = 'Y';

Line 874: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

870: SELECT max(po_chord_wf0.percentage_change(
871: POLLA.price_override, POLL.price_override))
872: INTO x_shipments_control.price_override_change
873: FROM PO_LINE_LOCATIONS_ALL POLL,
874: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
875: WHERE POLL.po_header_id = x_po_header_id
876: AND NVL(POLL.payment_type, 'NONE') <> 'DELIVERY' --
877: AND POLL.line_location_id = POLLA.line_location_id (+)
878: AND POLLA.latest_external_flag (+) = 'Y'

Line 890: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

886: SELECT max(po_chord_wf0.percentage_change(
887: POLLA.price_override, POLL.price_override))
888: INTO x_shipments_control.price_override_change
889: FROM PO_LINE_LOCATIONS_ALL POLL,
890: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
891: WHERE
892: POLL.po_release_id = x_po_release_id
893: AND POLL.line_location_id = POLLA.line_location_id (+)
894: AND POLLA.latest_external_flag (+) = 'Y';

Line 935: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

931: (POLL.quantity*POLL.price_override)) / l_min_acct_unit )* l_min_acct_unit
932: ))
933: INTO x_shipments_control.amount_change
934: FROM PO_LINE_LOCATIONS_ALL POLL,
935: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
936: WHERE POLL.po_header_id = x_po_header_id
937: -- : "line level" info should be ignored.
938: AND NVL(POLL.payment_type, 'NONE') NOT IN ('DELIVERY', 'ADVANCE')
939: AND POLL.line_location_id = POLLA.line_location_id (+)

Line 955: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

951: (POLL.quantity*POLL.price_override) ),l_precision )
952: ))
953: INTO x_shipments_control.amount_change
954: FROM PO_LINE_LOCATIONS_ALL POLL,
955: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
956: WHERE POLL.po_header_id = x_po_header_id
957: AND NVL(POLL.payment_type, 'NONE') NOT IN ('DELIVERY', 'ADVANCE')
958: AND POLL.line_location_id = POLLA.line_location_id (+)
959: AND POLLA.latest_external_flag (+) = 'Y'

Line 998: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

994: (POLL.quantity*POLL.price_override) ) / l_min_acct_unit )* l_min_acct_unit
995: ))
996: INTO x_shipments_control.amount_change
997: FROM PO_LINE_LOCATIONS_ALL POLL,
998: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
999: WHERE POLL.po_release_id = x_po_release_id
1000: AND POLL.line_location_id = POLLA.line_location_id (+)
1001: AND POLLA.latest_external_flag (+) = 'Y';
1002:

Line 1015: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

1011: (POLL.quantity*POLL.price_override) ),l_precision )
1012: ))
1013: INTO x_shipments_control.amount_change
1014: FROM PO_LINE_LOCATIONS_ALL POLL,
1015: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
1016: WHERE POLL.po_release_id = x_po_release_id
1017: AND POLL.line_location_id = POLLA.line_location_id (+)
1018: AND POLLA.latest_external_flag (+) = 'Y';
1019: END IF;

Line 1038: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

1034: BEGIN
1035: SELECT DISTINCT 'Y'
1036: INTO x_shipments_control.days_late_rcpt_allowed
1037: FROM PO_LINE_LOCATIONS_ALL POLL,
1038: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
1039: WHERE
1040: POLL.po_header_id = x_po_header_id
1041: AND POLL.line_location_id = POLLA.line_location_id (+)
1042: AND POLLA.latest_external_flag (+) = 'Y'

Line 1061: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

1057: BEGIN
1058: SELECT DISTINCT 'Y'
1059: INTO x_shipments_control.days_late_rcpt_allowed
1060: FROM PO_LINE_LOCATIONS_ALL POLL,
1061: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
1062: WHERE
1063: POLL.po_release_id = x_po_release_id
1064: AND POLL.line_location_id = POLLA.line_location_id (+)
1065: AND POLLA.latest_external_flag (+) = 'Y'