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.POS_TOTALS_PO_SV dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 70: po_line_locations_archive_all poll,

66: / x_min_unit )
67: * x_min_unit )
68: into x_po_total
69: FROM po_distributions_archive_all pod,
70: po_line_locations_archive_all poll,
71: po_lines_archive_all pol
72: WHERE pod.line_location_id = poll.line_location_id
73: AND poll.po_line_id = pol.po_line_id
74: AND pol.from_header_id = X_header_id

Line 87: po_line_locations_archive_all poll,

83: - pod.quantity_cancelled )
84: * poll.price_override)))
85: into x_po_total
86: FROM po_distributions_archive_all pod,
87: po_line_locations_archive_all poll,
88: po_lines_archive_all pol
89: WHERE pod.line_location_id = poll.line_location_id
90: AND poll.po_line_id = pol.po_line_id
91: AND pol.from_header_id = X_header_id

Line 111: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

107: * nvl(pll.price_override,0)
108: )
109: ,x_precision))
110: INTO x_po_total
111: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
112: WHERE PLL.po_header_id = x_header_id
113: AND PLL.LATEST_EXTERNAL_FLAG= 'Y'
114: AND PLL.shipment_type in ('BLANKET','SCHEDULED');
115:

Line 128: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

124: )
125: / x_min_unit)
126: * x_min_unit)
127: INTO x_po_total
128: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
129: WHERE PLL.po_header_id = x_header_id
130: AND PLL.LATEST_EXTERNAL_FLAG= 'Y'
131: AND PLL.shipment_type in ('BLANKET','SCHEDULED');
132:

Line 198: FROM po_line_locations_archive_all plla1

194: nvl(plla1.price_override, 0), x_precision)
195: )
196:
197: INTO X_po_total
198: FROM po_line_locations_archive_all plla1
199: where po_header_id = X_header_id
200: and shipment_type in ('PLANNED')
201: and revision_num = (
202: SELECT max(plla2.revision_num)

Line 203: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

199: where po_header_id = X_header_id
200: and shipment_type in ('PLANNED')
201: and revision_num = (
202: SELECT max(plla2.revision_num)
203: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
204: WHERE plla2.revision_num <= X_revision_num
205: AND plla2.line_location_id = plla1.line_location_id );
206: else
207: select sum(round((plla1.quantity -

Line 212: FROM po_line_locations_archive_all plla1 --po_line_locations_archive

208: nvl(plla1.quantity_cancelled,0)) *
209: nvl(plla1.price_override,0)/x_min_unit)*
210: x_min_unit)
211: INTO X_po_total
212: FROM po_line_locations_archive_all plla1 --po_line_locations_archive
213: WHERE po_header_id = X_header_id
214: AND shipment_type IN ('PLANNED')
215: AND revision_num = (
216: SELECT max( plla2.revision_num )

Line 217: FROM po_line_locations_archive_all plla2 --po_line_locations_archive

213: WHERE po_header_id = X_header_id
214: AND shipment_type IN ('PLANNED')
215: AND revision_num = (
216: SELECT max( plla2.revision_num )
217: FROM po_line_locations_archive_all plla2 --po_line_locations_archive
218: WHERE plla2.revision_num <= X_revision_num
219: AND plla2.line_location_id = plla1.line_location_id ) ;
220: end if;
221:

Line 282: FROM po_line_locations_archive_all plla1

278: ((plla1.quantity - nvl(plla1.quantity_cancelled,0)) *
279: nvl(plla1.price_override,0))
280: ) ,x_precision))
281: into X_po_total
282: FROM po_line_locations_archive_all plla1
283: WHERE po_release_id = X_release_id
284: AND shipment_type IN ('BLANKET','SCHEDULED')
285: AND revision_num = (
286: SELECT max( plla2.revision_num )

Line 287: FROM po_line_locations_archive_all plla2

283: WHERE po_release_id = X_release_id
284: AND shipment_type IN ('BLANKET','SCHEDULED')
285: AND revision_num = (
286: SELECT max( plla2.revision_num )
287: FROM po_line_locations_archive_all plla2
288: WHERE plla2.revision_num <= X_revision_num
289: AND plla2.line_location_id = plla1.line_location_id ) ;
290:
291: else

Line 300: FROM po_line_locations_archive_all plla1

296: ((plla1.quantity -nvl(plla1.quantity_cancelled,0)) *
297: nvl(plla1.price_override,0)))/x_min_unit)*
298: x_min_unit)
299: into X_po_total
300: FROM po_line_locations_archive_all plla1
301: WHERE po_release_id = X_release_id
302: AND shipment_type IN ('BLANKET','SCHEDULED')
303: AND revision_num = (
304: SELECT max( plla2.revision_num )

Line 305: FROM po_line_locations_archive_all plla2

301: WHERE po_release_id = X_release_id
302: AND shipment_type IN ('BLANKET','SCHEDULED')
303: AND revision_num = (
304: SELECT max( plla2.revision_num )
305: FROM po_line_locations_archive_all plla2
306: WHERE plla2.revision_num <= X_revision_num
307: AND plla2.line_location_id = plla1.line_location_id ) ;
308: end if;
309:

Line 425: FROM po_line_locations_archive_all plla1

421: (plla1.amount - nvl(plla1.amount_cancelled, 0)),
422: (plla1.quantity - nvl(plla1.quantity_cancelled,0))
423: * nvl(plla1.price_override,0))),x_precision))
424: INTO X_po_total
425: FROM po_line_locations_archive_all plla1
426: where plla1.po_line_id = x_po_line_id
427: and shipment_type in ('STANDARD','PLANNED')
428: and revision_num = (
429: SELECT max(plla2.revision_num)

Line 430: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

426: where plla1.po_line_id = x_po_line_id
427: and shipment_type in ('STANDARD','PLANNED')
428: and revision_num = (
429: SELECT max(plla2.revision_num)
430: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
431: WHERE plla2.revision_num <= x_revision_num
432: AND plla2.line_location_id = plla1.line_location_id );
433: else
434: select sum(round((

Line 441: FROM po_line_locations_archive_all plla1

437: (plla1.amount - nvl(plla1.amount_cancelled, 0)),
438: (plla1.quantity - nvl(plla1.quantity_cancelled,0))
439: * nvl(plla1.price_override,0)))/x_min_unit)*x_min_unit)
440: INTO X_po_total
441: FROM po_line_locations_archive_all plla1
442: WHERE plla1.po_line_id = x_po_line_id
443: AND shipment_type in ('STANDARD','PLANNED')
444: AND revision_num = (
445: SELECT max( plla2.revision_num )

Line 446: FROM po_line_locations_archive_all plla2

442: WHERE plla1.po_line_id = x_po_line_id
443: AND shipment_type in ('STANDARD','PLANNED')
444: AND revision_num = (
445: SELECT max( plla2.revision_num )
446: FROM po_line_locations_archive_all plla2
447: WHERE plla2.revision_num <= x_revision_num
448: AND plla2.line_location_id = plla1.line_location_id ) ;
449: end if;
450: else /* po_release_id is not null */

Line 459: FROM po_line_locations_archive_all plla1

455: (plla1.amount - nvl(plla1.amount_cancelled, 0)),
456: (plla1.quantity - nvl(plla1.quantity_cancelled,0))
457: * nvl(plla1.price_override,0))),x_precision))
458: INTO X_po_total
459: FROM po_line_locations_archive_all plla1
460: where plla1.po_line_id = x_po_line_id
461: and plla1.po_release_id = x_po_release_id
462: and shipment_type in ('BLANKET','SCHEDULED')
463: and revision_num = (

Line 465: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

461: and plla1.po_release_id = x_po_release_id
462: and shipment_type in ('BLANKET','SCHEDULED')
463: and revision_num = (
464: SELECT max(plla2.revision_num)
465: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
466: WHERE plla2.revision_num <= x_revision_num
467: AND plla2.line_location_id = plla1.line_location_id );
468: else
469: select sum(round((

Line 476: FROM po_line_locations_archive_all plla1

472: (plla1.amount - nvl(plla1.amount_cancelled, 0)),
473: (plla1.quantity - nvl(plla1.quantity_cancelled,0))
474: * nvl(plla1.price_override,0)))/x_min_unit)*x_min_unit)
475: INTO X_po_total
476: FROM po_line_locations_archive_all plla1
477: WHERE plla1.po_line_id = x_po_line_id
478: and plla1.po_release_id = x_po_release_id
479: AND shipment_type in ('BLANKET','SCHEDULED')
480: AND revision_num = (

Line 482: FROM po_line_locations_archive_all plla2

478: and plla1.po_release_id = x_po_release_id
479: AND shipment_type in ('BLANKET','SCHEDULED')
480: AND revision_num = (
481: SELECT max( plla2.revision_num )
482: FROM po_line_locations_archive_all plla2
483: WHERE plla2.revision_num <= x_revision_num
484: AND plla2.line_location_id = plla1.line_location_id ) ;
485: end if;
486: end if;

Line 518: po_line_locations_archive_all poll

514: INTO x_min_unit,
515: x_precision
516: FROM fnd_currencies fc,
517: po_headers_all pha,
518: po_line_locations_archive_all poll
519: WHERE poll.line_location_id = x_po_line_location_id
520: AND poll.po_header_id = pha.po_header_id
521: AND fc.currency_code = pha.currency_code
522: AND poll.latest_external_flag='Y';

Line 530: FROM po_line_locations_archive_all plla1

526: decode(plla1.quantity,
527: null, (plla1.amount - nvl(plla1.amount_cancelled, 0)),
528: (plla1.quantity - nvl(plla1.quantity_cancelled,0))* nvl(plla1.price_override,0)), x_precision)
529: INTO X_po_total
530: FROM po_line_locations_archive_all plla1
531: WHERE plla1.line_location_id = x_po_line_location_id
532: AND revision_num = (
533: SELECT max(plla2.revision_num)
534: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

Line 534: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

530: FROM po_line_locations_archive_all plla1
531: WHERE plla1.line_location_id = x_po_line_location_id
532: AND revision_num = (
533: SELECT max(plla2.revision_num)
534: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
535: WHERE plla2.revision_num <= X_revision_num
536: AND plla2.line_location_id = plla1.line_location_id );
537: else
538: select round(

Line 543: FROM po_line_locations_archive_all plla1

539: decode(plla1.quantity,
540: null, (plla1.amount - nvl(plla1.amount_cancelled,0)),
541: (plla1.quantity - nvl(plla1.quantity_cancelled,0))* nvl(plla1.price_override,0)) / x_min_unit) * x_min_unit
542: INTO X_po_total
543: FROM po_line_locations_archive_all plla1
544: WHERE plla1.line_location_id = x_po_line_location_id
545: AND revision_num = (
546: SELECT max( plla2.revision_num )
547: FROM po_line_locations_archive_all plla2

Line 547: FROM po_line_locations_archive_all plla2

543: FROM po_line_locations_archive_all plla1
544: WHERE plla1.line_location_id = x_po_line_location_id
545: AND revision_num = (
546: SELECT max( plla2.revision_num )
547: FROM po_line_locations_archive_all plla2
548: WHERE plla2.revision_num <= X_revision_num
549: AND plla2.line_location_id = plla1.line_location_id ) ;
550: end if;
551:

Line 582: po_line_locations_archive_all poll

578: INTO x_min_unit,
579: x_precision
580: FROM fnd_currencies fc,
581: po_headers_all pha,
582: po_line_locations_archive_all poll
583: WHERE poll.line_location_id = p_po_line_location_id
584: AND poll.po_header_id = pha.po_header_id
585: AND fc.currency_code = pha.currency_code
586: AND poll.latest_external_flag='Y';

Line 595: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA

591: 'QUANTITY', (NVL(PLLA.quantity,0)- NVL(PLLA.quantity_cancelled,0)) *
592: NVL(PLLA.price_override, 0)),
593: x_precision)
594: INTO p_amount_ordered
595: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
596: WHERE plla.line_location_id = p_po_line_location_id
597: AND revision_num = (
598: SELECT max(plla2.revision_num)
599: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

Line 599: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

595: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
596: WHERE plla.line_location_id = p_po_line_location_id
597: AND revision_num = (
598: SELECT max(plla2.revision_num)
599: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
600: WHERE plla2.revision_num <= p_revision_num
601: AND plla2.line_location_id = plla.line_location_id );
602:
603: SELECT round(DECODE(PLL.matching_basis,

Line 623: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA

619: 'QUANTITY', (NVL(PLLA.quantity,0)- nvl(PLLA.quantity_cancelled,0))
620: * NVL(PLLA.price_override, 0))
621: / x_min_unit) * x_min_unit)
622: INTO p_amount_ordered
623: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
624: WHERE plla.line_location_id = p_po_line_location_id
625: AND revision_num = (
626: SELECT max( plla2.revision_num )
627: FROM po_line_locations_archive_all plla2

Line 627: FROM po_line_locations_archive_all plla2

623: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
624: WHERE plla.line_location_id = p_po_line_location_id
625: AND revision_num = (
626: SELECT max( plla2.revision_num )
627: FROM po_line_locations_archive_all plla2
628: WHERE plla2.revision_num <= p_revision_num
629: AND plla2.line_location_id = plla.line_location_id ) ;
630:
631: