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_ALL

Line 129: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 151: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 177: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 201: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 229: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 252: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 281: FROM PO_LINE_LOCATIONS_ALL POLL,

277: -- Bug 5123672 Added query to check if date changed
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 (+)

Line 300: FROM PO_LINE_LOCATIONS_ALL POLL,

296:
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'

Line 317: FROM PO_LINE_LOCATIONS_ALL POLL,

313: -- Bug 5123672 Added query to check if date changed
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 (+)

Line 335: FROM PO_LINE_LOCATIONS_ALL POLL,

331:
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'

Line 354: FROM PO_LINE_LOCATIONS_ALL POLL,

350: -- Bug 5123672 Added query to check if date changed
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 (+)

Line 373: FROM PO_LINE_LOCATIONS_ALL POLL,

369:
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'

Line 390: FROM PO_LINE_LOCATIONS_ALL POLL,

386: -- Bug 5123672 Added query to check if date changed
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 (+)

Line 408: FROM PO_LINE_LOCATIONS_ALL POLL,

404:
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'

Line 430: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 452: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 479: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 500: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 526: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 547: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 573: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 595: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 623: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 637: FROM PO_LINE_LOCATIONS_ALL POLL,

633: ELSE
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';

Line 662: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 676: FROM PO_LINE_LOCATIONS_ALL POLL,

672: ELSE
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';

Line 702: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 725: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 748: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 785: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 808: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 836: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 852: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 873: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 889: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 934: FROM PO_LINE_LOCATIONS_ALL POLL,

930: decode(POLL.value_basis, 'RATE',POLL.amount,'FIXED PRICE', POLL.amount,
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')

Line 954: FROM PO_LINE_LOCATIONS_ALL POLL,

950: decode(POLL.value_basis, 'RATE',POLL.amount,'FIXED PRICE', POLL.amount,
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 (+)

Line 997: FROM PO_LINE_LOCATIONS_ALL POLL,

993: decode(POLL.value_basis, 'FIXED PRICE', POLL.amount,
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';

Line 1014: FROM PO_LINE_LOCATIONS_ALL POLL,

1010: decode(POLL.value_basis, 'FIXED PRICE', POLL.amount,
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';

Line 1037: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 1060: FROM PO_LINE_LOCATIONS_ALL POLL,

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