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

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
2489: pdd1.revision_num <= p_doc_revision);
2490:
2491: l_progress := '060';

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

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
2681: pdd1.revision_num <= p_doc_revision);
2682:
2683:

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

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
2709: pdd1.revision_num <= p_doc_revision);
2710:
2711: end if;

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

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
2739: pdd1.revision_num <= p_doc_revision);
2740:
2741: else

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

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
2767: pdd1.revision_num <= p_doc_revision);
2768:
2769: end if;

Line 5205: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

5201: BULK COLLECT INTO
5202: x_distribution_id_tbl
5203: , x_distribution_rev_num_tbl
5204: FROM
5205: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5206: , PO_SESSION_GT IDS
5207: WHERE POD.po_release_id = IDS.num1
5208: AND IDS.key = l_doc_level_id_key
5209: AND ( (l_revision_specified_flag = 'Y'

Line 5215: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

5211: OR
5212: (l_revision_specified_flag = 'N'
5213: AND POD.revision_num =
5214: (SELECT max(POD2.revision_num)
5215: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
5216: WHERE POD2.po_distribution_id = POD.po_distribution_id
5217: AND POD2.revision_num <= p_doc_revision_num) )
5218: )
5219: ;

Line 5236: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

5232: BULK COLLECT INTO
5233: x_distribution_id_tbl
5234: , x_distribution_rev_num_tbl
5235: FROM
5236: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5237: , PO_SESSION_GT IDS
5238: WHERE POD.po_header_id = IDS.num1
5239: AND POD.po_release_id IS NULL
5240: -- Don't pick up Release distributions when acting on a PPO/BPA/GA.

Line 5249: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

5245: OR
5246: (l_revision_specified_flag = 'N'
5247: AND POD.revision_num =
5248: (SELECT max(POD2.revision_num)
5249: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
5250: WHERE POD2.po_distribution_id = POD.po_distribution_id
5251: AND POD2.revision_num <= p_doc_revision_num) )
5252: )
5253: ;

Line 5270: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

5266: BULK COLLECT INTO
5267: x_distribution_id_tbl
5268: , x_distribution_rev_num_tbl
5269: FROM
5270: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5271: , PO_SESSION_GT IDS
5272: WHERE POD.po_line_id = IDS.num1
5273: AND POD.po_release_id IS NULL
5274: -- Don't pick up SR distributions when acting on a PPO.

Line 5283: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

5279: OR
5280: (l_revision_specified_flag = 'N'
5281: AND POD.revision_num =
5282: (SELECT max(POD2.revision_num)
5283: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
5284: WHERE POD2.po_distribution_id = POD.po_distribution_id
5285: AND POD2.revision_num <= p_doc_revision_num) )
5286: )
5287: ;

Line 5304: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

5300: BULK COLLECT INTO
5301: x_distribution_id_tbl
5302: , x_distribution_rev_num_tbl
5303: FROM
5304: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5305: , PO_SESSION_GT IDS
5306: WHERE POD.line_location_id = IDS.num1
5307: AND IDS.key = l_doc_level_id_key
5308: AND ( (l_revision_specified_flag = 'Y'

Line 5314: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

5310: OR
5311: (l_revision_specified_flag = 'N'
5312: AND POD.revision_num =
5313: (SELECT max(POD2.revision_num)
5314: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
5315: WHERE POD2.po_distribution_id = POD.po_distribution_id
5316: AND POD2.revision_num <= p_doc_revision_num) )
5317: )
5318: ;

Line 5335: PO_DISTRIBUTIONS_ARCHIVE_ALL POD

5331: BULK COLLECT INTO
5332: x_distribution_id_tbl
5333: , x_distribution_rev_num_tbl
5334: FROM
5335: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5336: , PO_SESSION_GT IDS
5337: WHERE POD.po_distribution_id = IDS.num1
5338: AND IDS.key = l_doc_level_id_key
5339: AND ( (l_revision_specified_flag = 'Y'

Line 5345: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

5341: OR
5342: (l_revision_specified_flag = 'N'
5343: AND POD.revision_num =
5344: (SELECT max(POD2.revision_num)
5345: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
5346: WHERE POD2.po_distribution_id = POD.po_distribution_id
5347: AND POD2.revision_num <= p_doc_revision_num) )
5348: )
5349: ;