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 90: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

86: * nvl(pll.price_override,0)
87: )
88: ,x_precision)),0)
89: INTO x_po_total
90: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
91: WHERE PLL.po_header_id = x_header_id
92: AND PLL.LATEST_EXTERNAL_FLAG= 'Y'
93: AND PLL.shipment_type in ('BLANKET','SCHEDULED');
94:

Line 107: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

103: )
104: / x_min_unit)
105: * x_min_unit),0)
106: INTO x_po_total
107: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
108: WHERE PLL.po_header_id = x_header_id
109: AND PLL.LATEST_EXTERNAL_FLAG= 'Y'
110: AND PLL.shipment_type in ('BLANKET','SCHEDULED');
111:

Line 177: FROM po_line_locations_archive_all plla1

173: nvl(plla1.price_override, 0), x_precision)
174: ),0)
175:
176: INTO X_po_total
177: FROM po_line_locations_archive_all plla1
178: where po_header_id = X_header_id
179: and shipment_type in ('PLANNED')
180: and revision_num = (
181: SELECT max(plla2.revision_num)

Line 182: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

178: where po_header_id = X_header_id
179: and shipment_type in ('PLANNED')
180: and revision_num = (
181: SELECT max(plla2.revision_num)
182: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
183: WHERE plla2.revision_num <= X_revision_num
184: AND plla2.line_location_id = plla1.line_location_id );
185: else
186: select Nvl(sum(round((plla1.quantity -

Line 191: FROM po_line_locations_archive_all plla1 --po_line_locations_archive

187: nvl(plla1.quantity_cancelled,0)) *
188: nvl(plla1.price_override,0)/x_min_unit)*
189: x_min_unit),0)
190: INTO X_po_total
191: FROM po_line_locations_archive_all plla1 --po_line_locations_archive
192: WHERE po_header_id = X_header_id
193: AND shipment_type IN ('PLANNED')
194: AND revision_num = (
195: SELECT max( plla2.revision_num )

Line 196: FROM po_line_locations_archive_all plla2 --po_line_locations_archive

192: WHERE po_header_id = X_header_id
193: AND shipment_type IN ('PLANNED')
194: AND revision_num = (
195: SELECT max( plla2.revision_num )
196: FROM po_line_locations_archive_all plla2 --po_line_locations_archive
197: WHERE plla2.revision_num <= X_revision_num
198: AND plla2.line_location_id = plla1.line_location_id ) ;
199: end if;
200:

Line 261: FROM po_line_locations_archive_all plla1

257: ((plla1.quantity - nvl(plla1.quantity_cancelled,0)) *
258: nvl(plla1.price_override,0))
259: ) ,x_precision)),0)
260: into X_po_total
261: FROM po_line_locations_archive_all plla1
262: WHERE po_release_id = X_release_id
263: AND shipment_type IN ('BLANKET','SCHEDULED')
264: AND revision_num = (
265: SELECT max( plla2.revision_num )

Line 266: FROM po_line_locations_archive_all plla2

262: WHERE po_release_id = X_release_id
263: AND shipment_type IN ('BLANKET','SCHEDULED')
264: AND revision_num = (
265: SELECT max( plla2.revision_num )
266: FROM po_line_locations_archive_all plla2
267: WHERE plla2.revision_num <= X_revision_num
268: AND plla2.line_location_id = plla1.line_location_id ) ;
269:
270: else

Line 279: FROM po_line_locations_archive_all plla1

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

Line 284: FROM po_line_locations_archive_all plla2

280: WHERE po_release_id = X_release_id
281: AND shipment_type IN ('BLANKET','SCHEDULED')
282: AND revision_num = (
283: SELECT max( plla2.revision_num )
284: FROM po_line_locations_archive_all plla2
285: WHERE plla2.revision_num <= X_revision_num
286: AND plla2.line_location_id = plla1.line_location_id ) ;
287: end if;
288:

Line 404: FROM po_line_locations_archive_all plla1

400: (plla1.amount - nvl(plla1.amount_cancelled, 0)),
401: (plla1.quantity - nvl(plla1.quantity_cancelled,0))
402: * nvl(plla1.price_override,0))),x_precision)),0)
403: INTO X_po_total
404: FROM po_line_locations_archive_all plla1
405: where plla1.po_line_id = x_po_line_id
406: and shipment_type in ('STANDARD','PLANNED')
407: and revision_num = (
408: SELECT max(plla2.revision_num)

Line 409: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

405: where plla1.po_line_id = x_po_line_id
406: and shipment_type in ('STANDARD','PLANNED')
407: and revision_num = (
408: SELECT max(plla2.revision_num)
409: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
410: WHERE plla2.revision_num <= x_revision_num
411: AND plla2.line_location_id = plla1.line_location_id );
412: else
413: select Nvl(sum(round((

Line 420: FROM po_line_locations_archive_all plla1

416: (plla1.amount - nvl(plla1.amount_cancelled, 0)),
417: (plla1.quantity - nvl(plla1.quantity_cancelled,0))
418: * nvl(plla1.price_override,0)))/x_min_unit)*x_min_unit),0)
419: INTO X_po_total
420: FROM po_line_locations_archive_all plla1
421: WHERE plla1.po_line_id = x_po_line_id
422: AND shipment_type in ('STANDARD','PLANNED')
423: AND revision_num = (
424: SELECT max( plla2.revision_num )

Line 425: FROM po_line_locations_archive_all plla2

421: WHERE plla1.po_line_id = x_po_line_id
422: AND shipment_type in ('STANDARD','PLANNED')
423: AND revision_num = (
424: SELECT max( plla2.revision_num )
425: FROM po_line_locations_archive_all plla2
426: WHERE plla2.revision_num <= x_revision_num
427: AND plla2.line_location_id = plla1.line_location_id ) ;
428: end if;
429: else /* po_release_id is not null */

Line 438: FROM po_line_locations_archive_all plla1

434: (plla1.amount - nvl(plla1.amount_cancelled, 0)),
435: (plla1.quantity - nvl(plla1.quantity_cancelled,0))
436: * nvl(plla1.price_override,0))),x_precision)),0)
437: INTO X_po_total
438: FROM po_line_locations_archive_all plla1
439: where plla1.po_line_id = x_po_line_id
440: and plla1.po_release_id = x_po_release_id
441: and shipment_type in ('BLANKET','SCHEDULED')
442: and revision_num = (

Line 444: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

440: and plla1.po_release_id = x_po_release_id
441: and shipment_type in ('BLANKET','SCHEDULED')
442: and revision_num = (
443: SELECT max(plla2.revision_num)
444: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
445: WHERE plla2.revision_num <= x_revision_num
446: AND plla2.line_location_id = plla1.line_location_id );
447: else
448: select Nvl(sum(round((

Line 455: FROM po_line_locations_archive_all plla1

451: (plla1.amount - nvl(plla1.amount_cancelled, 0)),
452: (plla1.quantity - nvl(plla1.quantity_cancelled,0))
453: * nvl(plla1.price_override,0)))/x_min_unit)*x_min_unit),0)
454: INTO X_po_total
455: FROM po_line_locations_archive_all plla1
456: WHERE plla1.po_line_id = x_po_line_id
457: and plla1.po_release_id = x_po_release_id
458: AND shipment_type in ('BLANKET','SCHEDULED')
459: AND revision_num = (

Line 461: FROM po_line_locations_archive_all plla2

457: and plla1.po_release_id = x_po_release_id
458: AND shipment_type in ('BLANKET','SCHEDULED')
459: AND revision_num = (
460: SELECT max( plla2.revision_num )
461: FROM po_line_locations_archive_all plla2
462: WHERE plla2.revision_num <= x_revision_num
463: AND plla2.line_location_id = plla1.line_location_id ) ;
464: end if;
465: end if;

Line 497: po_line_locations_archive_all poll

493: INTO x_min_unit,
494: x_precision
495: FROM fnd_currencies fc,
496: po_headers_all pha,
497: po_line_locations_archive_all poll
498: WHERE poll.line_location_id = x_po_line_location_id
499: AND poll.po_header_id = pha.po_header_id
500: AND fc.currency_code = pha.currency_code
501: AND poll.latest_external_flag='Y';

Line 509: FROM po_line_locations_archive_all plla1

505: decode(plla1.quantity,
506: null, (plla1.amount - nvl(plla1.amount_cancelled, 0)),
507: (plla1.quantity - nvl(plla1.quantity_cancelled,0))* nvl(plla1.price_override,0)), x_precision)
508: INTO X_po_total
509: FROM po_line_locations_archive_all plla1
510: WHERE plla1.line_location_id = x_po_line_location_id
511: AND revision_num = (
512: SELECT max(plla2.revision_num)
513: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

Line 513: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

509: FROM po_line_locations_archive_all plla1
510: WHERE plla1.line_location_id = x_po_line_location_id
511: AND revision_num = (
512: SELECT max(plla2.revision_num)
513: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
514: WHERE plla2.revision_num <= X_revision_num
515: AND plla2.line_location_id = plla1.line_location_id );
516: else
517: select round(

Line 522: FROM po_line_locations_archive_all plla1

518: decode(plla1.quantity,
519: null, (plla1.amount - nvl(plla1.amount_cancelled,0)),
520: (plla1.quantity - nvl(plla1.quantity_cancelled,0))* nvl(plla1.price_override,0)) / x_min_unit) * x_min_unit
521: INTO X_po_total
522: FROM po_line_locations_archive_all plla1
523: WHERE plla1.line_location_id = x_po_line_location_id
524: AND revision_num = (
525: SELECT max( plla2.revision_num )
526: FROM po_line_locations_archive_all plla2

Line 526: FROM po_line_locations_archive_all plla2

522: FROM po_line_locations_archive_all plla1
523: WHERE plla1.line_location_id = x_po_line_location_id
524: AND revision_num = (
525: SELECT max( plla2.revision_num )
526: FROM po_line_locations_archive_all plla2
527: WHERE plla2.revision_num <= X_revision_num
528: AND plla2.line_location_id = plla1.line_location_id ) ;
529: end if;
530:

Line 561: po_line_locations_archive_all poll

557: INTO x_min_unit,
558: x_precision
559: FROM fnd_currencies fc,
560: po_headers_all pha,
561: po_line_locations_archive_all poll
562: WHERE poll.line_location_id = p_po_line_location_id
563: AND poll.po_header_id = pha.po_header_id
564: AND fc.currency_code = pha.currency_code
565: AND poll.latest_external_flag='Y';

Line 574: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA

570: 'QUANTITY', (NVL(PLLA.quantity,0)- NVL(PLLA.quantity_cancelled,0)) *
571: NVL(PLLA.price_override, 0)),
572: x_precision)
573: INTO p_amount_ordered
574: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
575: WHERE plla.line_location_id = p_po_line_location_id
576: AND revision_num = (
577: SELECT max(plla2.revision_num)
578: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

Line 578: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2

574: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
575: WHERE plla.line_location_id = p_po_line_location_id
576: AND revision_num = (
577: SELECT max(plla2.revision_num)
578: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL plla2
579: WHERE plla2.revision_num <= p_revision_num
580: AND plla2.line_location_id = plla.line_location_id );
581:
582: SELECT round(DECODE(PLL.matching_basis,

Line 602: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA

598: 'QUANTITY', (NVL(PLLA.quantity,0)- nvl(PLLA.quantity_cancelled,0))
599: * NVL(PLLA.price_override, 0))
600: / x_min_unit) * x_min_unit)
601: INTO p_amount_ordered
602: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
603: WHERE plla.line_location_id = p_po_line_location_id
604: AND revision_num = (
605: SELECT max( plla2.revision_num )
606: FROM po_line_locations_archive_all plla2

Line 606: FROM po_line_locations_archive_all plla2

602: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
603: WHERE plla.line_location_id = p_po_line_location_id
604: AND revision_num = (
605: SELECT max( plla2.revision_num )
606: FROM po_line_locations_archive_all plla2
607: WHERE plla2.revision_num <= p_revision_num
608: AND plla2.line_location_id = plla.line_location_id ) ;
609:
610: