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.RCV_ROI_TRANSACTION dependencies on PO_LINES

Line 234: po_lines pl,

230: pll.value_basis , --Complex Work
231: pl.purchase_basis,
232: pll.matching_basis --Complex Work
233: FROM po_line_locations pll,
234: po_lines pl,
235: po_headers ph
236: WHERE ph.po_header_id = pl.po_header_id
237: AND pl.po_line_id = pll.po_line_id
238: AND ph.po_header_id = v_header_id

Line 1524: FROM po_lines

1520: NVL(matching_basis, 'QUANTITY')
1521: INTO x_cascaded_table(n).value_basis,
1522: x_cascaded_table(n).purchase_basis,
1523: x_cascaded_table(n).matching_basis
1524: FROM po_lines
1525: WHERE po_line_id = x_cascaded_table(n).po_line_id;
1526: ELSE
1527: -- we require line info for receiving against services lines
1528: x_cascaded_table(n).matching_basis := 'QUANTITY';

Line 2728: po_lines pl,

2724: NVL(pll.enforce_ship_to_location_code, 'NONE') enforce_ship_to_location_code,
2725: TO_NUMBER(NULL) shipment_line_id, --shipment_line_id
2726: pl.item_id
2727: FROM po_line_locations pll,
2728: po_lines pl,
2729: po_headers ph
2730: WHERE ph.po_header_id = header_id
2731: AND pll.po_header_id = header_id
2732: AND pl.line_num = NVL(v_po_line_num, pl.line_num)

Line 2761: po_lines pl,

2757: v_vendor_product_num VARCHAR2
2758: ) IS
2759: SELECT COUNT(*)
2760: FROM po_line_locations pll,
2761: po_lines pl,
2762: po_headers ph
2763: WHERE ph.po_header_id = header_id
2764: AND pll.po_header_id = header_id
2765: AND pl.line_num = NVL(v_po_line_num, pl.line_num)

Line 2785: ***** followed by PO_LINES_ALL which is followed by PO_LINE_LOCATIONS_ALL

2781: /***** Bug # 1553154
2782: ***** There was a performance issue since the cursor COUNT_DISTRIBUTIONS
2783: ***** was driving through PO_LINE_LOCATIONS_ALL. Modified the Select
2784: ***** statement so that it will drive through PO_HEADERS_ALL
2785: ***** followed by PO_LINES_ALL which is followed by PO_LINE_LOCATIONS_ALL
2786: ***** so that there is an improvement in performance.
2787: *****/
2788: CURSOR distributions(
2789: header_id NUMBER,

Line 2841: po_lines pl,

2837: TO_NUMBER(NULL) shipment_line_id, -- shipment_line_id
2838: pl.item_id
2839: FROM po_distributions pod,
2840: po_line_locations pll,
2841: po_lines pl,
2842: po_headers ph
2843: WHERE ph.po_header_id = header_id
2844: AND pl.po_header_id = ph.po_header_id
2845: AND pll.po_line_id = pl.po_line_id

Line 2868: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by

2864: /***** Bug # 1553154
2865: ***** There was a performance issue since the cursor DISTRIBUTIONS
2866: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL
2867: ***** Modified the Select statement so that it will drive through
2868: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by
2869: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by
2870: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in
2871: ***** Performance
2872: *****/

Line 2887: po_lines pl,

2883: ) IS
2884: SELECT COUNT(*)
2885: FROM po_distributions pod,
2886: po_line_locations pll,
2887: po_lines pl,
2888: po_headers ph
2889: WHERE ph.po_header_id = header_id
2890: AND pl.po_header_id = ph.po_header_id
2891: AND pll.po_line_id = pl.po_line_id

Line 3069: FROM po_lines

3065: AND temp_cascaded_table(current_n).po_line_id IS NOT NULL THEN --{
3066: BEGIN
3067: SELECT line_num
3068: INTO temp_cascaded_table(current_n).document_line_num
3069: FROM po_lines
3070: WHERE po_line_id = temp_cascaded_table(current_n).po_line_id;
3071: EXCEPTION
3072: WHEN OTHERS THEN
3073: IF (g_asn_debug = 'Y') THEN

Line 3720: po_lines pl,

3716: IF (x_is_asn = FALSE) THEN --{
3717: SELECT COUNT(*)
3718: INTO x_temp_count
3719: FROM po_line_locations pll,
3720: po_lines pl,
3721: po_headers ph
3722: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
3723: AND pll.po_header_id = ph.po_header_id
3724: AND pl.line_num = NVL(temp_cascaded_table(current_n).document_line_num, pl.line_num)

Line 3762: po_lines pl,

3758: x_ship_to_organization_id,
3759: x_ship_to_location_id,
3760: x_vendor_product_num
3761: FROM po_line_locations pll,
3762: po_lines pl,
3763: po_headers ph
3764: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
3765: AND pll.po_header_id = ph.po_header_id
3766: AND pl.line_num = NVL(temp_cascaded_table(current_n).document_line_num, pl.line_num)

Line 3795: po_lines pl,

3791: SELECT COUNT(*)
3792: INTO x_temp_count
3793: FROM po_distributions pod,
3794: po_line_locations pll,
3795: po_lines pl,
3796: po_headers ph
3797: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
3798: AND pll.po_header_id = ph.po_header_id
3799: AND pll.line_location_id = pod.line_location_id

Line 3840: po_lines pl,

3836: x_ship_to_location_id,
3837: x_vendor_product_num
3838: FROM po_distributions pod,
3839: po_line_locations pll,
3840: po_lines pl,
3841: po_headers ph
3842: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
3843: AND pll.po_header_id = ph.po_header_id
3844: AND pll.line_location_id = pod.line_location_id

Line 3894: po_lines pl,

3890: l_receipt_source_code,
3891: l_shipment_line_status_code,
3892: l_asn_line_flag
3893: FROM po_line_locations pll,
3894: po_lines pl,
3895: po_headers ph,
3896: rcv_shipment_headers rsh,
3897: rcv_shipment_lines rsl
3898: WHERE rsh.shipment_header_id = temp_cascaded_table(current_n).shipment_header_id

Line 5279: po_lines pl,

5275: pll.ship_to_location_id,
5276: NVL(pll.enforce_ship_to_location_code, 'NONE') enforce_ship_to_location_code,
5277: pl.item_id
5278: FROM po_line_locations pll,
5279: po_lines pl,
5280: po_headers ph
5281: WHERE pl.po_line_id = v_po_line_id
5282: AND pll.po_line_id = v_po_line_id
5283: AND ph.po_header_id = pl.po_header_id

Line 5302: po_lines pl,

5298: v_po_release_id NUMBER
5299: ) IS
5300: SELECT COUNT(*)
5301: FROM po_line_locations pll,
5302: po_lines pl,
5303: po_headers ph
5304: WHERE pl.po_line_id = v_po_line_id
5305: AND pll.po_line_id = v_po_line_id
5306: AND ph.po_header_id = pl.po_header_id

Line 5360: po_lines pl,

5356: NVL(pll.enforce_ship_to_location_code, 'NONE') enforce_ship_to_location_code,
5357: pl.item_id
5358: FROM po_distributions pod,
5359: po_line_locations pll,
5360: po_lines pl,
5361: po_headers ph
5362: WHERE pl.po_line_id = v_po_line_id
5363: AND pll.po_line_id = v_po_line_id
5364: AND ph.po_header_id = pl.po_header_id

Line 5387: po_lines pl,

5383: ) IS
5384: SELECT COUNT(*)
5385: FROM po_distributions pod,
5386: po_line_locations pll,
5387: po_lines pl,
5388: po_headers ph
5389: WHERE pl.po_line_id = v_po_line_id
5390: AND pll.po_line_id = v_po_line_id
5391: AND ph.po_header_id = pl.po_header_id

Line 5497: po_lines pol

5493: */
5494: SELECT COUNT(*)
5495: INTO l_time_count
5496: FROM hxc_time_building_blocks bb,
5497: po_lines pol
5498: WHERE bb.time_building_block_id = x_cascaded_table(n).timecard_id
5499: AND bb.object_version_number = x_cascaded_table(n).timecard_ovn
5500: AND bb.SCOPE = 'TIMECARD'
5501: AND bb.resource_type = 'PERSON'

Line 5587: FROM po_lines

5583: AND temp_cascaded_table(current_n).po_line_id IS NOT NULL THEN --{
5584: BEGIN
5585: SELECT line_num
5586: INTO temp_cascaded_table(current_n).document_line_num
5587: FROM po_lines
5588: WHERE po_line_id = temp_cascaded_table(current_n).po_line_id;
5589: EXCEPTION
5590: WHEN OTHERS THEN
5591: IF (g_asn_debug = 'Y') THEN

Line 5945: po_lines pl

5941: INTO x_temp_count
5942: FROM DUAL
5943: WHERE EXISTS(SELECT 1
5944: FROM po_line_locations pll,
5945: po_lines pl
5946: WHERE pl.po_line_id = temp_cascaded_table(current_n).po_line_id
5947: AND NVL(pll.po_release_id, 0) = NVL(temp_cascaded_table(current_n).po_release_id, NVL(pll.po_release_id, 0))
5948: AND pll.line_location_id = NVL(temp_cascaded_table(current_n).po_line_location_id, pll.line_location_id)
5949: AND pll.po_line_id = pl.po_line_id);

Line 5968: po_lines pl,

5964: x_cancel_flag,
5965: x_closed_code,
5966: x_shipment_type
5967: FROM po_line_locations pll,
5968: po_lines pl,
5969: po_headers ph
5970: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
5971: AND pll.po_header_id = ph.po_header_id
5972: AND pl.line_num = NVL(temp_cascaded_table(current_n).document_line_num, pl.line_num)

Line 5984: po_lines pl,

5980: SELECT COUNT(*)
5981: INTO x_temp_count
5982: FROM po_distributions pod,
5983: po_line_locations pll,
5984: po_lines pl,
5985: po_headers ph
5986: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
5987: AND pll.po_header_id = ph.po_header_id
5988: AND pll.line_location_id = pod.line_location_id

Line 6013: po_lines pl,

6009: x_closed_code,
6010: x_shipment_type
6011: FROM po_distributions pod,
6012: po_line_locations pll,
6013: po_lines pl,
6014: po_headers ph
6015: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
6016: AND pll.po_header_id = ph.po_header_id
6017: AND pll.line_location_id = pod.line_location_id

Line 6850: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511

6846: item_revision_record rcv_shipment_line_sv.item_id_record_type;
6847: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
6848: item_id_record rcv_shipment_line_sv.item_id_record_type;
6849: l_asn_sub_item_txn varchar2(1); --Bug: 5598511
6850: l_pol_item_id po_lines_all.item_id%type; --Bug: 5598511
6851: BEGIN
6852: -- validate item id
6853: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
6854: RETURN;

Line 7550: l_job_id po_lines.job_id%TYPE;

7546: n IN BINARY_INTEGER,
7547: x_header_record IN rcv_roi_preprocessor.header_rec_type
7548: ) IS
7549: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
7550: l_job_id po_lines.job_id%TYPE;
7551: l_item_description po_lines.item_description%TYPE;
7552: l_category_id po_lines.category_id%TYPE;
7553: x_error_status VARCHAR2(1);
7554: BEGIN

Line 7551: l_item_description po_lines.item_description%TYPE;

7547: x_header_record IN rcv_roi_preprocessor.header_rec_type
7548: ) IS
7549: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
7550: l_job_id po_lines.job_id%TYPE;
7551: l_item_description po_lines.item_description%TYPE;
7552: l_category_id po_lines.category_id%TYPE;
7553: x_error_status VARCHAR2(1);
7554: BEGIN
7555: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 7552: l_category_id po_lines.category_id%TYPE;

7548: ) IS
7549: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
7550: l_job_id po_lines.job_id%TYPE;
7551: l_item_description po_lines.item_description%TYPE;
7552: l_category_id po_lines.category_id%TYPE;
7553: x_error_status VARCHAR2(1);
7554: BEGIN
7555: x_error_status := rcv_error_pkg.g_ret_sts_error;
7556:

Line 7634: FROM po_lines

7630: END IF;
7631:
7632: SELECT NVL(MAX(job_id), 0)
7633: INTO l_job_id
7634: FROM po_lines
7635: WHERE po_line_id = x_cascaded_table(n).po_line_id
7636: AND job_id = x_cascaded_table(n).job_id;
7637:
7638: IF (g_asn_debug = 'Y') THEN

Line 7652: * null then in po_lines. For other POs

7648: IF (x_cascaded_table(n).item_description IS NOT NULL) THEN
7649:
7650: /* Complex work.
7651: * For work confirmations check in shipment level. If
7652: * null then in po_lines. For other POs
7653: * check in po_lines.
7654: */
7655:
7656: If (nvl(x_header_record.header_record.asn_type,'STD') = 'WC') then --{

Line 7653: * check in po_lines.

7649:
7650: /* Complex work.
7651: * For work confirmations check in shipment level. If
7652: * null then in po_lines. For other POs
7653: * check in po_lines.
7654: */
7655:
7656: If (nvl(x_header_record.header_record.asn_type,'STD') = 'WC') then --{
7657:

Line 7671: FROM po_lines

7667: WHEN NO_DATA_FOUND THEN
7668: BEGIN
7669: SELECT (item_description)
7670: INTO l_item_description
7671: FROM po_lines
7672: WHERE po_line_id = x_cascaded_table(n).po_line_id
7673: AND item_description =
7674: x_cascaded_table(n).item_description;
7675: EXCEPTION

Line 7686: FROM po_lines

7682: else --}{
7683: BEGIN
7684: SELECT (item_description)
7685: INTO l_item_description
7686: FROM po_lines
7687: WHERE po_line_id = x_cascaded_table(n).po_line_id
7688: AND item_description = x_cascaded_table(n).item_description;
7689: EXCEPTION
7690: WHEN NO_DATA_FOUND THEN

Line 7709: FROM po_lines

7705:
7706: IF (x_cascaded_table(n).category_id IS NOT NULL) THEN
7707: SELECT NVL(MAX(category_id), 0)
7708: INTO l_category_id
7709: FROM po_lines
7710: WHERE po_line_id = x_cascaded_table(n).po_line_id
7711: AND category_id = x_cascaded_table(n).category_id;
7712:
7713: IF (g_asn_debug = 'Y') THEN

Line 7994: x_po_line_id po_lines.po_line_id%TYPE;

7990: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,
7991: x_header_record IN rcv_roi_preprocessor.header_rec_type
7992: ) IS
7993: x_po_vendor_id po_headers.vendor_id%TYPE := NULL;
7994: x_po_line_id po_lines.po_line_id%TYPE;
7995: x_po_vendor_site_id po_headers.vendor_site_id%TYPE := NULL;
7996: x_progress VARCHAR2(3);
7997: x_error_status VARCHAR2(1);
7998: BEGIN

Line 8004: FROM po_lines

8000:
8001: IF (x_ref_integrity_rec.vendor_item_num IS NOT NULL) THEN
8002: SELECT NVL(MAX(po_line_id), 0)
8003: INTO x_po_line_id
8004: FROM po_lines
8005: WHERE po_line_id = x_ref_integrity_rec.po_line_id
8006: AND vendor_product_num = x_ref_integrity_rec.vendor_item_num;
8007:
8008: IF (x_po_line_id = 0) THEN

Line 9425: po_lines pol

9421: FROM rcv_supply rsup,
9422: rcv_transactions rt,
9423: rcv_shipment_lines rsl,
9424: po_headers poh,
9425: po_lines pol
9426: WHERE rt.transaction_id = v_parent_trx_id
9427: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)
9428: AND rsup.supply_type_code = 'RECEIVING'
9429: AND poh.po_header_id = rsup.po_header_id

Line 9532: po_lines pol,

9528: FROM rcv_supply rsup,
9529: rcv_transactions rt,
9530: rcv_shipment_lines rsl,
9531: po_headers poh,
9532: po_lines pol,
9533: po_distributions pod
9534: WHERE rt.transaction_id = v_parent_trx_id
9535: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)
9536: AND rsup.supply_type_code = 'RECEIVING'

Line 9647: po_lines pol,

9643: FROM rcv_supply rsup,
9644: rcv_transactions rt,
9645: rcv_shipment_lines rsl,
9646: po_headers poh,
9647: po_lines pol,
9648: po_distributions pod
9649: WHERE rt.transaction_id = v_parent_trx_id
9650: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)
9651: AND rsup.supply_type_code = 'RECEIVING'

Line 9755: po_lines pol,

9751: FROM rcv_supply rsup,
9752: rcv_transactions rt,
9753: rcv_shipment_lines rsl,
9754: po_headers poh,
9755: po_lines pol,
9756: po_distributions pod
9757: WHERE rt.transaction_id = v_parent_trx_id
9758: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)
9759: AND rsup.supply_type_code = 'RECEIVING'

Line 9791: l_value_basis po_lines.order_type_lookup_code%TYPE;

9787: temp_index NUMBER;
9788: l_supply_code rcv_supply.supply_type_code%TYPE;
9789: l_transaction_type rcv_transactions.transaction_type%TYPE;
9790: /* FPJ SERVICES */
9791: l_value_basis po_lines.order_type_lookup_code%TYPE;
9792: l_purchase_basis po_lines.purchase_basis%TYPE;
9793: l_matching_basis po_lines.matching_basis%TYPE;
9794: l_service_po_line_id po_lines.po_line_id%TYPE;
9795: l_total_rec_quantity NUMBER;

Line 9792: l_purchase_basis po_lines.purchase_basis%TYPE;

9788: l_supply_code rcv_supply.supply_type_code%TYPE;
9789: l_transaction_type rcv_transactions.transaction_type%TYPE;
9790: /* FPJ SERVICES */
9791: l_value_basis po_lines.order_type_lookup_code%TYPE;
9792: l_purchase_basis po_lines.purchase_basis%TYPE;
9793: l_matching_basis po_lines.matching_basis%TYPE;
9794: l_service_po_line_id po_lines.po_line_id%TYPE;
9795: l_total_rec_quantity NUMBER;
9796: l_converted_distribution_qty NUMBER;

Line 9793: l_matching_basis po_lines.matching_basis%TYPE;

9789: l_transaction_type rcv_transactions.transaction_type%TYPE;
9790: /* FPJ SERVICES */
9791: l_value_basis po_lines.order_type_lookup_code%TYPE;
9792: l_purchase_basis po_lines.purchase_basis%TYPE;
9793: l_matching_basis po_lines.matching_basis%TYPE;
9794: l_service_po_line_id po_lines.po_line_id%TYPE;
9795: l_total_rec_quantity NUMBER;
9796: l_converted_distribution_qty NUMBER;
9797: l_distribution_qty NUMBER;

Line 9794: l_service_po_line_id po_lines.po_line_id%TYPE;

9790: /* FPJ SERVICES */
9791: l_value_basis po_lines.order_type_lookup_code%TYPE;
9792: l_purchase_basis po_lines.purchase_basis%TYPE;
9793: l_matching_basis po_lines.matching_basis%TYPE;
9794: l_service_po_line_id po_lines.po_line_id%TYPE;
9795: l_total_rec_quantity NUMBER;
9796: l_converted_distribution_qty NUMBER;
9797: l_distribution_qty NUMBER;
9798: l_converted_transaction_qty NUMBER;

Line 10348: from po_lines_all

10344: where po_header_id = x_po_transferrec.po_head_id;
10345:
10346: select line_num
10347: into l_po_line_num
10348: from po_lines_all
10349: where po_line_id = x_po_transferrec.po_line_id;
10350:
10351: select shipment_num
10352: into l_po_line_loc_num

Line 10415: FROM po_lines

10411: NVL(matching_basis, 'QUANTITY')
10412: INTO l_value_basis,
10413: l_purchase_basis,
10414: l_matching_basis
10415: FROM po_lines
10416: WHERE po_line_id = l_service_po_line_id;
10417:
10418: IF (l_matching_basis = 'AMOUNT') THEN
10419: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;

Line 11723: po_lines pl

11719: IF (x_cascaded_table(n).receipt_source_code = 'VENDOR') THEN --{
11720: SELECT NVL(pll.price_override, pl.unit_price)
11721: INTO x_cascaded_table(n).po_unit_price
11722: FROM po_line_locations pll,
11723: po_lines pl
11724: WHERE pll.line_location_id = x_cascaded_table(n).po_line_location_id
11725: AND pl.po_line_id = x_cascaded_table(n).po_line_id
11726: AND pl.po_line_id = pll.po_line_id;
11727:

Line 11939: FROM po_lines

11935: NVL(matching_basis, 'QUANTITY')
11936: INTO x_cascaded_table(n).value_basis,
11937: x_cascaded_table(n).purchase_basis,
11938: x_cascaded_table(n).matching_basis
11939: FROM po_lines
11940: WHERE po_line_id = x_cascaded_table(n).po_line_id;
11941: ELSE
11942: -- we require line info for receiving against services lines
11943: x_cascaded_table(n).matching_basis := 'QUANTITY';

Line 12073: po_lines pol

12069: rsl.ussgl_transaction_code
12070: FROM rcv_transactions rt,
12071: rcv_shipment_lines rsl,
12072: po_headers poh,
12073: po_lines pol
12074: WHERE rt.transaction_id = v_parent_trx_id
12075: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)
12076: AND ( rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT', 'MATCH')
12077: OR ( rt.transaction_type IN('RETURN TO VENDOR', 'RETURN TO CUSTOMER')

Line 13202: po_lines pol

13198: rsl.ussgl_transaction_code
13199: FROM rcv_transactions rt,
13200: rcv_shipment_lines rsl,
13201: po_headers poh,
13202: po_lines pol
13203: WHERE rt.transaction_id = v_parent_trx_id
13204: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)
13205: AND ( rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT', 'MATCH')
13206: OR ( rt.transaction_type IN('RETURN TO VENDOR', 'RETURN TO CUSTOMER')

Line 13549: po_lines pol

13545: */
13546: SELECT COUNT(*)
13547: INTO l_time_count
13548: FROM hxc_time_building_blocks bb,
13549: po_lines pol
13550: WHERE bb.time_building_block_id = x_cascaded_table(n).timecard_id
13551: AND bb.object_version_number = x_cascaded_table(n).timecard_ovn
13552: AND bb.SCOPE = 'TIMECARD'
13553: AND bb.resource_type = 'PERSON'

Line 14445: po_lines pl

14441: IF (x_cascaded_table(n).receipt_source_code = 'VENDOR') THEN --{
14442: SELECT NVL(pll.price_override, pl.unit_price)
14443: INTO x_cascaded_table(n).po_unit_price
14444: FROM po_line_locations pll,
14445: po_lines pl
14446: WHERE pll.line_location_id = x_cascaded_table(n).po_line_location_id
14447: AND pl.po_line_id = x_cascaded_table(n).po_line_id
14448: AND pl.po_line_id = pll.po_line_id;
14449:

Line 15455: po_lines_all pl

15451: INTO x_cascaded_table(n).value_basis,
15452: x_cascaded_table(n).matching_basis,
15453: x_cascaded_table(n).purchase_basis
15454: FROM po_line_locations_all pll,
15455: po_lines_all pl
15456: WHERE pl.po_line_id = x_cascaded_table(n).po_line_id
15457: and pl.po_line_id = pll.po_line_id
15458: and pll.line_location_id =x_cascaded_table(n).po_line_location_id;
15459: exception

Line 15498: po_lines_all pl

15494: INTO x_cascaded_table(n).value_basis,
15495: x_cascaded_table(n).matching_basis,
15496: x_cascaded_table(n).purchase_basis
15497: FROM po_line_locations_all pll,
15498: po_lines_all pl
15499: WHERE pl.po_line_id = x_cascaded_table(n).po_line_id
15500: and pl.po_line_id = pll.po_line_id
15501: and pll.shipment_num =
15502: x_cascaded_table(n).document_shipment_line_num;

Line 15550: FROM po_lines_all

15546: NVL(matching_basis, 'QUANTITY')
15547: INTO x_cascaded_table(n).value_basis,
15548: x_cascaded_table(n).purchase_basis,
15549: x_cascaded_table(n).matching_basis
15550: FROM po_lines_all
15551: WHERE po_line_id = x_cascaded_table(n).po_line_id;
15552: exception
15553: when no_data_found then
15554: IF (g_asn_debug = 'Y') THEN