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 318: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 336: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 356: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 375: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 393: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 411: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 434: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 456: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 483: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 504: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 530: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 551: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 577: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 599: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 627: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 641: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 666: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 680: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 706: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 729: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 752: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 789: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 812: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 840: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 856: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 877: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 893: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 938: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 958: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 1001: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 1018: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 1041: FROM PO_LINE_LOCATIONS_ALL POLL,

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

Line 1064: FROM PO_LINE_LOCATIONS_ALL POLL,

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