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_DISTRIBUTIONS_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 2619: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1

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
2621: pdd1.revision_num <= p_doc_revision);
2622:
2623: l_progress := '060';

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 2811: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1

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
2813: pdd1.revision_num <= p_doc_revision);
2814:
2815:

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 2839: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1

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
2841: pdd1.revision_num <= p_doc_revision);
2842:
2843: end if;

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 2869: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1

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
2871: pdd1.revision_num <= p_doc_revision);
2872:
2873: else

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 2897: AND POD.REVISION_NUM = (SELECT MAX(pdd1.revision_num) FROM PO_DISTRIBUTIONS_ARCHIVE_ALL PDD1

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
2899: pdd1.revision_num <= p_doc_revision);
2900:
2901: end if;

Line 5413: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

5409: BULK COLLECT INTO
5410: x_distribution_id_tbl
5411: , x_distribution_rev_num_tbl
5412: FROM
5413: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5414: , PO_SESSION_GT IDS
5415: WHERE POD.po_release_id = IDS.num1
5416: AND IDS.key = l_doc_level_id_key
5417: AND ( (l_revision_specified_flag = 'Y'

Line 5423: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

5419: OR
5420: (l_revision_specified_flag = 'N'
5421: AND POD.revision_num =
5422: (SELECT max(POD2.revision_num)
5423: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
5424: WHERE POD2.po_distribution_id = POD.po_distribution_id
5425: AND POD2.revision_num <= p_doc_revision_num) )
5426: )
5427: ;

Line 5444: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

5440: BULK COLLECT INTO
5441: x_distribution_id_tbl
5442: , x_distribution_rev_num_tbl
5443: FROM
5444: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5445: , PO_SESSION_GT IDS
5446: WHERE POD.po_header_id = IDS.num1
5447: AND POD.po_release_id IS NULL
5448: -- Don't pick up Release distributions when acting on a PPO/BPA/GA.

Line 5457: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

5453: OR
5454: (l_revision_specified_flag = 'N'
5455: AND POD.revision_num =
5456: (SELECT max(POD2.revision_num)
5457: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
5458: WHERE POD2.po_distribution_id = POD.po_distribution_id
5459: AND POD2.revision_num <= p_doc_revision_num) )
5460: )
5461: ;

Line 5478: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

5474: BULK COLLECT INTO
5475: x_distribution_id_tbl
5476: , x_distribution_rev_num_tbl
5477: FROM
5478: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5479: , PO_SESSION_GT IDS
5480: WHERE POD.po_line_id = IDS.num1
5481: AND POD.po_release_id IS NULL
5482: -- Don't pick up SR distributions when acting on a PPO.

Line 5491: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

5487: OR
5488: (l_revision_specified_flag = 'N'
5489: AND POD.revision_num =
5490: (SELECT max(POD2.revision_num)
5491: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
5492: WHERE POD2.po_distribution_id = POD.po_distribution_id
5493: AND POD2.revision_num <= p_doc_revision_num) )
5494: )
5495: ;

Line 5512: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

5508: BULK COLLECT INTO
5509: x_distribution_id_tbl
5510: , x_distribution_rev_num_tbl
5511: FROM
5512: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5513: , PO_SESSION_GT IDS
5514: WHERE POD.line_location_id = IDS.num1
5515: AND IDS.key = l_doc_level_id_key
5516: AND ( (l_revision_specified_flag = 'Y'

Line 5522: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

5518: OR
5519: (l_revision_specified_flag = 'N'
5520: AND POD.revision_num =
5521: (SELECT max(POD2.revision_num)
5522: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
5523: WHERE POD2.po_distribution_id = POD.po_distribution_id
5524: AND POD2.revision_num <= p_doc_revision_num) )
5525: )
5526: ;

Line 5543: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

5539: BULK COLLECT INTO
5540: x_distribution_id_tbl
5541: , x_distribution_rev_num_tbl
5542: FROM
5543: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5544: , PO_SESSION_GT IDS
5545: WHERE POD.po_distribution_id = IDS.num1
5546: AND IDS.key = l_doc_level_id_key
5547: AND ( (l_revision_specified_flag = 'Y'

Line 5553: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

5549: OR
5550: (l_revision_specified_flag = 'N'
5551: AND POD.revision_num =
5552: (SELECT max(POD2.revision_num)
5553: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
5554: WHERE POD2.po_distribution_id = POD.po_distribution_id
5555: AND POD2.revision_num <= p_doc_revision_num) )
5556: )
5557: ;