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_CORE_S dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 2344: --SQL JOIN- Location id in PO_LINE_LOCATIONS_ARCHIVE_ALL and PO_DISTRIBUTIONS_ARCHIVE_ALL

2340: END IF; -- if l_base_currency <> l_po_currency
2341: l_progress := '050';
2342: --SQL WHAT- This query returns the total amount for an archived SPO
2343: --SQL WHY- To check if archived amount different from working copy amt. for a po in contract terms
2344: --SQL JOIN- Location id in PO_LINE_LOCATIONS_ARCHIVE_ALL and PO_DISTRIBUTIONS_ARCHIVE_ALL
2345: SELECT nvl(sum(round( ( (round( ( ( decode(POD.quantity_ordered, NULL,
2346: (nvl(POD.amount_ordered,0) -
2347: nvl(POD.amount_cancelled,0)
2348: ),

Line 2370: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2366: nvl(l_base_min_unit,1)
2367: ), 0
2368: )
2369: INTO l_archive_total_amt
2370: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2371: WHERE PLL.po_header_id = p_object_id
2372: AND PLL.shipment_type in ('STANDARD')
2373: AND PLL.line_location_id = POD.line_location_id
2374: AND PLL.LATEST_EXTERNAL_FLAG = 'Y'

Line 2454: --SQL JOIN- Location id in PO_LINE_LOCATIONS_ARCHIVE_ALL and PO_DISTRIBUTIONS_ARCHIVE_ALL

2450: END IF; -- if l_base_currency <> l_po_currency
2451: l_progress := '050';
2452: --SQL WHAT- This query returns the total amount for an archived SPO
2453: --SQL WHY- To derive the total amount for an archived PO revision
2454: --SQL JOIN- Location id in PO_LINE_LOCATIONS_ARCHIVE_ALL and PO_DISTRIBUTIONS_ARCHIVE_ALL
2455: SELECT nvl(sum(round( ( (round( ( ( decode(POD.quantity_ordered, NULL,
2456: (nvl(POD.amount_ordered,0) -
2457: nvl(POD.amount_cancelled,0)
2458: ),

Line 2480: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2476: nvl(l_base_min_unit,1)
2477: ), 0
2478: )
2479: INTO l_archive_total_amt
2480: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2481: WHERE PLL.po_header_id = p_object_id
2482: AND PLL.shipment_type in ('STANDARD')
2483: AND PLL.line_location_id = POD.line_location_id
2484: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

Line 2484: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

2480: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2481: WHERE PLL.po_header_id = p_object_id
2482: AND PLL.shipment_type in ('STANDARD')
2483: AND PLL.line_location_id = POD.line_location_id
2484: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2485: WHERE pll1.line_location_id = pll.line_location_id AND
2486: pll1.revision_num <= p_doc_revision)
2487: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1
2488: WHERE pdd1.po_distribution_id = pod.po_distribution_id AND

Line 2527: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2523: * nvl(pll.price_override,0)
2524: )
2525: ),l_precision))
2526: INTO l_archive_total_amt
2527: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2528: WHERE PLL.line_location_id = p_object_id AND
2529: PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2530: pll1.line_location_id = pll.line_location_id AND
2531: pll1.revision_num <= p_doc_revision) ;

Line 2529: PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE

2525: ),l_precision))
2526: INTO l_archive_total_amt
2527: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2528: WHERE PLL.line_location_id = p_object_id AND
2529: PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2530: pll1.line_location_id = pll.line_location_id AND
2531: pll1.revision_num <= p_doc_revision) ;
2532:
2533: else

Line 2548: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2544: * nvl(pll.price_override,0)
2545: )
2546: /l_min_unit) * l_min_unit))
2547: INTO l_archive_total_amt
2548: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2549: WHERE PLL.line_location_id = p_object_id AND
2550: PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2551: pll1.line_location_id = pll.line_location_id AND
2552: pll1.revision_num <= p_doc_revision) ;

Line 2550: PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE

2546: /l_min_unit) * l_min_unit))
2547: INTO l_archive_total_amt
2548: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2549: WHERE PLL.line_location_id = p_object_id AND
2550: PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2551: pll1.line_location_id = pll.line_location_id AND
2552: pll1.revision_num <= p_doc_revision) ;
2553:
2554: end if;

Line 2586: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2582: * nvl(pll.price_override,0)
2583: )
2584: ),l_precision))
2585: INTO l_archive_total_amt
2586: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2587: WHERE PLL.po_line_id = p_object_id
2588: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')
2589: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2590: pll1.line_location_id = pll.line_location_id AND

Line 2589: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE

2585: INTO l_archive_total_amt
2586: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2587: WHERE PLL.po_line_id = p_object_id
2588: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')
2589: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2590: pll1.line_location_id = pll.line_location_id AND
2591: pll1.revision_num <= p_doc_revision) ;
2592:
2593: else

Line 2609: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2605: * nvl(pll.price_override,0)
2606: )
2607: / l_min_unit) * l_min_unit))
2608: INTO l_archive_total_amt
2609: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2610: WHERE PLL.po_line_id = p_object_id
2611: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')
2612: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2613: pll1.line_location_id = pll.line_location_id AND

Line 2612: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE

2608: INTO l_archive_total_amt
2609: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2610: WHERE PLL.po_line_id = p_object_id
2611: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')
2612: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2613: pll1.line_location_id = pll.line_location_id AND
2614: pll1.revision_num <= p_doc_revision) ;
2615:
2616:

Line 2672: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2668: )
2669: * POD.rate
2670: ,l_precision),l_base_precision)),0)
2671: INTO l_archive_total_amt
2672: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2673: WHERE PLL.po_release_id = p_object_id
2674: AND PLL.line_location_id = POD.line_location_id
2675: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2676: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

Line 2676: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

2672: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2673: WHERE PLL.po_release_id = p_object_id
2674: AND PLL.line_location_id = POD.line_location_id
2675: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2676: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2677: WHERE pll1.line_location_id = pll.line_location_id AND
2678: pll1.revision_num <= p_doc_revision)
2679: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1
2680: WHERE pdd1.po_distribution_id = pod.po_distribution_id AND

Line 2700: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2696: )
2697: * POD.rate /
2698: l_min_unit) * l_min_unit , l_base_precision)),0)
2699: INTO l_archive_total_amt
2700: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2701: WHERE PLL.po_release_id = p_object_id
2702: AND PLL.line_location_id = POD.line_location_id
2703: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2704: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

Line 2704: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

2700: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2701: WHERE PLL.po_release_id = p_object_id
2702: AND PLL.line_location_id = POD.line_location_id
2703: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2704: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2705: WHERE pll1.line_location_id = pll.line_location_id AND
2706: pll1.revision_num <= p_doc_revision)
2707: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1
2708: WHERE pdd1.po_distribution_id = pod.po_distribution_id AND

Line 2730: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2726: * POD.rate
2727: , l_precision)
2728: / l_base_min_unit ) * l_base_min_unit) ,0)
2729: INTO l_archive_total_amt
2730: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2731: WHERE PLL.po_release_id = p_object_id
2732: AND PLL.line_location_id = POD.line_location_id
2733: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2734: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

Line 2734: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

2730: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2731: WHERE PLL.po_release_id = p_object_id
2732: AND PLL.line_location_id = POD.line_location_id
2733: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2734: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2735: WHERE pll1.line_location_id = pll.line_location_id AND
2736: pll1.revision_num <= p_doc_revision)
2737: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1
2738: WHERE pdd1.po_distribution_id = pod.po_distribution_id AND

Line 2758: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2754: * POD.rate /
2755: l_min_unit) * l_min_unit / l_base_min_unit)
2756: * l_base_min_unit) , 0)
2757: INTO l_archive_total_amt
2758: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2759: WHERE PLL.po_release_id = p_object_id
2760: AND PLL.line_location_id = POD.line_location_id
2761: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2762: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

Line 2762: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

2758: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2759: WHERE PLL.po_release_id = p_object_id
2760: AND PLL.line_location_id = POD.line_location_id
2761: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2762: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2763: WHERE pll1.line_location_id = pll.line_location_id AND
2764: pll1.revision_num <= p_doc_revision)
2765: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1
2766: WHERE pdd1.po_distribution_id = pod.po_distribution_id AND

Line 2809: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2805: nvl(pll.price_override,0))
2806: )
2807: ,l_precision))
2808: INTO l_archive_total_amt
2809: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2810: WHERE PLL.po_release_id = p_object_id
2811: AND PLL.shipment_type in ( 'SCHEDULED','BLANKET')
2812: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2813: WHERE pll1.line_location_id = pll.line_location_id AND

Line 2812: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

2808: INTO l_archive_total_amt
2809: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2810: WHERE PLL.po_release_id = p_object_id
2811: AND PLL.shipment_type in ( 'SCHEDULED','BLANKET')
2812: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2813: WHERE pll1.line_location_id = pll.line_location_id AND
2814: pll1.revision_num <= p_doc_revision);
2815:
2816: else

Line 2837: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2833: )
2834: /l_min_unit) *
2835: l_min_unit)
2836: INTO l_archive_total_amt
2837: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2838: WHERE PLL.po_release_id = p_object_id
2839: AND PLL.shipment_type in ( 'SCHEDULED','BLANKET')
2840: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2841: WHERE pll1.line_location_id = pll.line_location_id AND

Line 2840: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

2836: INTO l_archive_total_amt
2837: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2838: WHERE PLL.po_release_id = p_object_id
2839: AND PLL.shipment_type in ( 'SCHEDULED','BLANKET')
2840: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2841: WHERE pll1.line_location_id = pll.line_location_id AND
2842: pll1.revision_num <= p_doc_revision);
2843:
2844: end if;