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 319: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 337: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 357: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 376: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 394: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 412: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 435: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

431: BEGIN
432: SELECT DISTINCT 'Y'
433: INTO x_shipments_control.last_accept_date
434: FROM PO_LINE_LOCATIONS_ALL POLL,
435: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
436: WHERE
437: POLL.po_header_id = x_po_header_id
438: AND POLL.line_location_id = POLLA.line_location_id (+)
439: AND POLLA.latest_external_flag (+) = 'Y'

Line 457: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

453: BEGIN
454: SELECT DISTINCT 'Y'
455: INTO x_shipments_control.last_accept_date
456: FROM PO_LINE_LOCATIONS_ALL POLL,
457: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
458: WHERE
459: POLL.po_release_id = x_po_release_id
460: AND POLL.line_location_id = POLLA.line_location_id (+)
461: AND POLLA.latest_external_flag (+) = 'Y'

Line 484: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

480: BEGIN
481: SELECT DISTINCT 'Y'
482: INTO x_shipments_control.taxable_flag
483: FROM PO_LINE_LOCATIONS_ALL POLL,
484: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
485: WHERE
486: POLL.po_header_id = x_po_header_id
487: AND POLL.line_location_id = POLLA.line_location_id (+)
488: AND POLLA.latest_external_flag (+) = 'Y'

Line 505: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

501: BEGIN
502: SELECT DISTINCT 'Y'
503: INTO x_shipments_control.taxable_flag
504: FROM PO_LINE_LOCATIONS_ALL POLL,
505: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
506: WHERE
507: POLL.po_release_id = x_po_release_id
508: AND POLL.line_location_id = POLLA.line_location_id (+)
509: AND POLLA.latest_external_flag (+) = 'Y'

Line 531: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

527: BEGIN
528: SELECT DISTINCT 'Y'
529: INTO x_shipments_control.cancel_flag
530: FROM PO_LINE_LOCATIONS_ALL POLL,
531: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
532: WHERE
533: POLL.po_header_id = x_po_header_id
534: AND POLL.line_location_id = POLLA.line_location_id (+)
535: AND POLLA.latest_external_flag (+) = 'Y'

Line 552: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

548: BEGIN
549: SELECT DISTINCT 'Y'
550: INTO x_shipments_control.cancel_flag
551: FROM PO_LINE_LOCATIONS_ALL POLL,
552: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
553: WHERE
554: POLL.po_release_id = x_po_release_id
555: AND POLL.line_location_id = POLLA.line_location_id (+)
556: AND POLLA.latest_external_flag (+) = 'Y'

Line 578: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

574: BEGIN
575: SELECT DISTINCT 'Y'
576: INTO x_shipments_control.closed_code
577: FROM PO_LINE_LOCATIONS_ALL POLL,
578: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
579: WHERE
580: POLL.po_header_id = x_po_header_id
581: AND POLL.line_location_id = POLLA.line_location_id (+)
582: AND POLLA.latest_external_flag (+) = 'Y'

Line 600: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

596: BEGIN
597: SELECT DISTINCT 'Y'
598: INTO x_shipments_control.closed_code
599: FROM PO_LINE_LOCATIONS_ALL POLL,
600: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
601: WHERE
602: POLL.po_release_id = x_po_release_id
603: AND POLL.line_location_id = POLLA.line_location_id (+)
604: AND POLLA.latest_external_flag (+) = 'Y'

Line 628: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 642: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 667: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 681: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 707: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 730: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 753: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 790: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 813: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

809: BEGIN
810: SELECT DISTINCT 'Y'
811: INTO x_shipments_control.price_override
812: FROM PO_LINE_LOCATIONS_ALL POLL,
813: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
814: WHERE
815: POLL.po_release_id = x_po_release_id
816: AND POLL.line_location_id = POLLA.line_location_id (+)
817: AND POLLA.latest_external_flag (+) = 'Y'

Line 841: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 857: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 878: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 894: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 939: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 959: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 1002: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 1019: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

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

Line 1042: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

1038: BEGIN
1039: SELECT DISTINCT 'Y'
1040: INTO x_shipments_control.days_late_rcpt_allowed
1041: FROM PO_LINE_LOCATIONS_ALL POLL,
1042: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
1043: WHERE
1044: POLL.po_header_id = x_po_header_id
1045: AND POLL.line_location_id = POLLA.line_location_id (+)
1046: AND POLLA.latest_external_flag (+) = 'Y'

Line 1065: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

1061: BEGIN
1062: SELECT DISTINCT 'Y'
1063: INTO x_shipments_control.days_late_rcpt_allowed
1064: FROM PO_LINE_LOCATIONS_ALL POLL,
1065: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
1066: WHERE
1067: POLL.po_release_id = x_po_release_id
1068: AND POLL.line_location_id = POLLA.line_location_id (+)
1069: AND POLLA.latest_external_flag (+) = 'Y'