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 2476: --SQL JOIN- Location id in PO_LINE_LOCATIONS_ARCHIVE_ALL and PO_DISTRIBUTIONS_ARCHIVE_ALL

2472: END IF; -- if l_base_currency <> l_po_currency
2473: l_progress := '050';
2474: --SQL WHAT- This query returns the total amount for an archived SPO
2475: --SQL WHY- To check if archived amount different from working copy amt. for a po in contract terms
2476: --SQL JOIN- Location id in PO_LINE_LOCATIONS_ARCHIVE_ALL and PO_DISTRIBUTIONS_ARCHIVE_ALL
2477: SELECT nvl(sum(round( ( (round( ( ( decode(POD.quantity_ordered, NULL,
2478: (nvl(POD.amount_ordered,0) -
2479: nvl(POD.amount_cancelled,0)
2480: ),

Line 2502: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2498: nvl(l_base_min_unit,1)
2499: ), 0
2500: )
2501: INTO l_archive_total_amt
2502: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2503: WHERE PLL.po_header_id = p_object_id
2504: AND PLL.shipment_type in ('STANDARD')
2505: AND PLL.line_location_id = POD.line_location_id
2506: AND PLL.LATEST_EXTERNAL_FLAG = 'Y'

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

2582: END IF; -- if l_base_currency <> l_po_currency
2583: l_progress := '050';
2584: --SQL WHAT- This query returns the total amount for an archived SPO
2585: --SQL WHY- To derive the total amount for an archived PO revision
2586: --SQL JOIN- Location id in PO_LINE_LOCATIONS_ARCHIVE_ALL and PO_DISTRIBUTIONS_ARCHIVE_ALL
2587: SELECT nvl(sum(round( ( (round( ( ( decode(POD.quantity_ordered, NULL,
2588: (nvl(POD.amount_ordered,0) -
2589: nvl(POD.amount_cancelled,0)
2590: ),

Line 2612: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2608: nvl(l_base_min_unit,1)
2609: ), 0
2610: )
2611: INTO l_archive_total_amt
2612: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2613: WHERE PLL.po_header_id = p_object_id
2614: AND PLL.shipment_type in ('STANDARD')
2615: AND PLL.line_location_id = POD.line_location_id
2616: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

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

2612: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2613: WHERE PLL.po_header_id = p_object_id
2614: AND PLL.shipment_type in ('STANDARD')
2615: AND PLL.line_location_id = POD.line_location_id
2616: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2617: WHERE pll1.line_location_id = pll.line_location_id AND
2618: pll1.revision_num <= p_doc_revision)
2619: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1
2620: WHERE pdd1.po_distribution_id = pod.po_distribution_id AND

Line 2659: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2655: * nvl(pll.price_override,0)
2656: )
2657: ),l_precision))
2658: INTO l_archive_total_amt
2659: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2660: WHERE PLL.line_location_id = p_object_id AND
2661: PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2662: pll1.line_location_id = pll.line_location_id AND
2663: pll1.revision_num <= p_doc_revision) ;

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

2657: ),l_precision))
2658: INTO l_archive_total_amt
2659: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2660: WHERE PLL.line_location_id = p_object_id AND
2661: PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2662: pll1.line_location_id = pll.line_location_id AND
2663: pll1.revision_num <= p_doc_revision) ;
2664:
2665: else

Line 2680: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2676: * nvl(pll.price_override,0)
2677: )
2678: /l_min_unit) * l_min_unit))
2679: INTO l_archive_total_amt
2680: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2681: WHERE PLL.line_location_id = p_object_id AND
2682: PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2683: pll1.line_location_id = pll.line_location_id AND
2684: pll1.revision_num <= p_doc_revision) ;

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

2678: /l_min_unit) * l_min_unit))
2679: INTO l_archive_total_amt
2680: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2681: WHERE PLL.line_location_id = p_object_id AND
2682: PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2683: pll1.line_location_id = pll.line_location_id AND
2684: pll1.revision_num <= p_doc_revision) ;
2685:
2686: end if;

Line 2718: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2714: * nvl(pll.price_override,0)
2715: )
2716: ),l_precision))
2717: INTO l_archive_total_amt
2718: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2719: WHERE PLL.po_line_id = p_object_id
2720: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')
2721: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2722: pll1.line_location_id = pll.line_location_id AND

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

2717: INTO l_archive_total_amt
2718: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2719: WHERE PLL.po_line_id = p_object_id
2720: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')
2721: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2722: pll1.line_location_id = pll.line_location_id AND
2723: pll1.revision_num <= p_doc_revision) ;
2724:
2725: else

Line 2741: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2737: * nvl(pll.price_override,0)
2738: )
2739: / l_min_unit) * l_min_unit))
2740: INTO l_archive_total_amt
2741: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2742: WHERE PLL.po_line_id = p_object_id
2743: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')
2744: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2745: pll1.line_location_id = pll.line_location_id AND

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

2740: INTO l_archive_total_amt
2741: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2742: WHERE PLL.po_line_id = p_object_id
2743: AND PLL.shipment_type in ( 'STANDARD','BLANKET','PLANNED')
2744: AND PLL.revision_num = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1 WHERE
2745: pll1.line_location_id = pll.line_location_id AND
2746: pll1.revision_num <= p_doc_revision) ;
2747:
2748:

Line 2804: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2800: )
2801: * POD.rate
2802: ,l_precision),l_base_precision)),0)
2803: INTO l_archive_total_amt
2804: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2805: WHERE PLL.po_release_id = p_object_id
2806: AND PLL.line_location_id = POD.line_location_id
2807: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2808: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

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

2804: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2805: WHERE PLL.po_release_id = p_object_id
2806: AND PLL.line_location_id = POD.line_location_id
2807: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2808: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2809: WHERE pll1.line_location_id = pll.line_location_id AND
2810: pll1.revision_num <= p_doc_revision)
2811: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1
2812: WHERE pdd1.po_distribution_id = pod.po_distribution_id AND

Line 2832: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2828: )
2829: * POD.rate /
2830: l_min_unit) * l_min_unit , l_base_precision)),0)
2831: INTO l_archive_total_amt
2832: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2833: WHERE PLL.po_release_id = p_object_id
2834: AND PLL.line_location_id = POD.line_location_id
2835: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2836: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

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

2832: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2833: WHERE PLL.po_release_id = p_object_id
2834: AND PLL.line_location_id = POD.line_location_id
2835: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2836: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2837: WHERE pll1.line_location_id = pll.line_location_id AND
2838: pll1.revision_num <= p_doc_revision)
2839: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1
2840: WHERE pdd1.po_distribution_id = pod.po_distribution_id AND

Line 2862: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2858: * POD.rate
2859: , l_precision)
2860: / l_base_min_unit ) * l_base_min_unit) ,0)
2861: INTO l_archive_total_amt
2862: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2863: WHERE PLL.po_release_id = p_object_id
2864: AND PLL.line_location_id = POD.line_location_id
2865: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2866: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

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

2862: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2863: WHERE PLL.po_release_id = p_object_id
2864: AND PLL.line_location_id = POD.line_location_id
2865: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2866: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2867: WHERE pll1.line_location_id = pll.line_location_id AND
2868: pll1.revision_num <= p_doc_revision)
2869: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1
2870: WHERE pdd1.po_distribution_id = pod.po_distribution_id AND

Line 2890: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2886: * POD.rate /
2887: l_min_unit) * l_min_unit / l_base_min_unit)
2888: * l_base_min_unit) , 0)
2889: INTO l_archive_total_amt
2890: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2891: WHERE PLL.po_release_id = p_object_id
2892: AND PLL.line_location_id = POD.line_location_id
2893: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2894: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1

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

2890: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD, PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2891: WHERE PLL.po_release_id = p_object_id
2892: AND PLL.line_location_id = POD.line_location_id
2893: AND PLL.shipment_type in ('SCHEDULED','BLANKET')
2894: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2895: WHERE pll1.line_location_id = pll.line_location_id AND
2896: pll1.revision_num <= p_doc_revision)
2897: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1
2898: WHERE pdd1.po_distribution_id = pod.po_distribution_id AND

Line 2941: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2937: nvl(pll.price_override,0))
2938: )
2939: ,l_precision))
2940: INTO l_archive_total_amt
2941: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2942: WHERE PLL.po_release_id = p_object_id
2943: AND PLL.shipment_type in ( 'SCHEDULED','BLANKET')
2944: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2945: WHERE pll1.line_location_id = pll.line_location_id AND

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

2940: INTO l_archive_total_amt
2941: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2942: WHERE PLL.po_release_id = p_object_id
2943: AND PLL.shipment_type in ( 'SCHEDULED','BLANKET')
2944: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2945: WHERE pll1.line_location_id = pll.line_location_id AND
2946: pll1.revision_num <= p_doc_revision);
2947:
2948: else

Line 2969: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL

2965: )
2966: /l_min_unit) *
2967: l_min_unit)
2968: INTO l_archive_total_amt
2969: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2970: WHERE PLL.po_release_id = p_object_id
2971: AND PLL.shipment_type in ( 'SCHEDULED','BLANKET')
2972: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2973: WHERE pll1.line_location_id = pll.line_location_id AND

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

2968: INTO l_archive_total_amt
2969: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL
2970: WHERE PLL.po_release_id = p_object_id
2971: AND PLL.shipment_type in ( 'SCHEDULED','BLANKET')
2972: AND PLL.REVISION_NUM = (SELECT MAX(pll1.revision_num) FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLL1
2973: WHERE pll1.line_location_id = pll.line_location_id AND
2974: pll1.revision_num <= p_doc_revision);
2975:
2976: end if;