APPS.PO_RCO_VALIDATION_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 75: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%TYPE;

71:
72: -- added for retroactive pricing checks
73: l_retropricing VARCHAR2(20) := '';
74: l_quantity_received NUMBER;
75: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%TYPE;
76: l_quantity_billed NUMBER;
77: l_call_price_break BOOLEAN := TRUE;
78:
79: l_req_line_id NUMBER;

Line 214: po_line_locations_all plla

210: l_accrue_on_receipt_flag,
211: l_quantity_billed
212: FROM
213: po_requisition_lines_all prla,
214: po_line_locations_all plla
215: WHERE prla.requisition_line_id = l_req_line_id
216: AND prla.line_location_id = plla.line_location_id;
217:
218: BEGIN

Line 694: po_line_locations_all plla,

690: l_err_req_line_id,
691: l_err_req_dist_id
692: FROM
693: po_lines_all pla,
694: po_line_locations_all plla,
695: po_distributions_all pda,
696: po_requisition_lines_all prla,
697: po_req_distributions_all prda
698: WHERE

Line 720: po_line_locations_all plla,

716: l_err_req_dist_num,
717: l_err_req_line_id,
718: l_err_req_dist_id
719: FROM
720: po_line_locations_all plla,
721: po_distributions_all pda,
722: po_requisition_lines_all prla,
723: po_req_distributions_all prda
724: WHERE

Line 755: po_line_locations_all plla,

751: x_return_msg := 'VQ004';
752: SELECT plla.quantity_received
753: INTO l_qty_old_rec
754: FROM
755: po_line_locations_all plla,
756: po_distributions_all pda
757: WHERE plla.line_location_id = pda.line_location_id
758: AND pda.po_distribution_id = p_po_change_table(s).document_distribution_id;
759:

Line 765: po_line_locations_all plla,

761:
762: SELECT SUM(plla.quantity_received) + p_po_change_table(s).new_quantity
763: INTO l_qty_new_rec
764: FROM
765: po_line_locations_all plla,
766: po_distributions_all pda1,
767: po_distributions_all pda2
768: WHERE plla.line_location_id = pda1.line_location_id
769: AND pda1.po_distribution_id <> p_po_change_table(s).document_distribution_id

Line 791: po_line_locations_all plla,

787: l_err_req_line_id,
788: l_err_req_dist_id
789: FROM
790: po_lines_all pla,
791: po_line_locations_all plla,
792: po_distributions_all pda,
793: po_requisition_lines_all prla,
794: po_req_distributions_all prda
795: WHERE

Line 817: po_line_locations_all plla,

813: l_err_req_dist_num,
814: l_err_req_line_id,
815: l_err_req_dist_id
816: FROM
817: po_line_locations_all plla,
818: po_distributions_all pda,
819: po_requisition_lines_all prla,
820: po_req_distributions_all prda
821: WHERE

Line 1272: FROM po_line_locations_all

1268: INTO l_ship_quantity,
1269: l_ship_to_location_id,
1270: l_ship_to_organization_id,
1271: l_need_by_date
1272: FROM po_line_locations_all
1273: WHERE line_location_id = p_po_change_table(i).document_line_location_id;
1274:
1275: p_progress := 'G2-2' || to_char(l_po_change_table_count) ||' '|| to_char(i) ||' '|| to_char(p_po_change_table(i).document_line_location_id);
1276: p_po_change_table(l_po_tbl_index) := po_chg_request_pvt.create_pos_change_rec(

Line 1427: po_line_locations_all plla,

1423: INTO
1424: l_current_hdr_id,
1425: l_current_rel_id
1426: FROM
1427: po_line_locations_all plla,
1428: po_requisition_lines_all prla
1429: WHERE prla.line_location_id = plla.line_location_id
1430: AND prla.requisition_line_id = p_req_change_table(l_current_row_id).document_line_id;
1431:

Line 1464: po_line_locations_all plla,

1460: INTO
1461: l_hdr_id,
1462: l_rel_id
1463: FROM
1464: po_line_locations_all plla,
1465: po_requisition_lines_all prla
1466: WHERE prla.line_location_id = plla.line_location_id
1467: AND prla.requisition_line_id = p_req_change_table(i).document_line_id;
1468:

Line 2121: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;

2117: l_po_ship_to_loc_id NUMBER;
2118: l_po_ship_to_org_id NUMBER;
2119: l_item_id NUMBER;
2120: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;
2121: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
2122: l_po_to_req_rate NUMBER;
2123: l_release_num NUMBER;
2124: l_old_start_date DATE;
2125: l_old_end_date DATE;

Line 2208: po_line_locations_all plla,

2204: l_old_po_amount
2205: FROM
2206: po_headers_all pha,
2207: po_lines_all pla,
2208: po_line_locations_all plla,
2209: po_req_distributions_all prda,
2210: po_requisition_lines_all prla,
2211: po_requisition_headers_all prha,
2212: po_distributions_all pda

Line 2289: po_line_locations_all plla,

2285: l_old_po_amount
2286: FROM
2287: po_headers_all pha,
2288: po_lines_all pla,
2289: po_line_locations_all plla,
2290: po_requisition_lines_all prla,
2291: po_requisition_headers_all prha
2292: WHERE
2293: prla.requisition_line_id = req_change_record_tbl(req_index).document_line_id

Line 2379: po_line_locations_all plla,

2375: FROM
2376: po_headers_all pha,
2377: po_releases_all pra,
2378: po_lines_all pla,
2379: po_line_locations_all plla,
2380: po_distributions_all pda,
2381: po_req_distributions_all prda,
2382: po_requisition_lines_all prla,
2383: po_requisition_headers_all prha

Line 2462: po_line_locations_all plla,

2458: FROM
2459: po_headers_all pha,
2460: po_releases_all pra,
2461: po_lines_all pla,
2462: po_line_locations_all plla,
2463: po_requisition_lines_all prla,
2464: po_requisition_headers_all prha
2465: WHERE
2466: prla.requisition_line_id = req_change_record_tbl(req_index).document_line_id

Line 2637: l_header_id po_line_locations_all.po_header_id%TYPE;

2633: ----------------------------------------------------------------*/
2634: PROCEDURE is_on_complex_work_order(p_line_loc_id IN NUMBER,
2635: x_return_status OUT NOCOPY VARCHAR2)
2636: IS
2637: l_header_id po_line_locations_all.po_header_id%TYPE;
2638: l_api_name VARCHAR2(100) := 'is_on_complex_work_order()';
2639: BEGIN
2640:
2641: x_return_status := 'N';

Line 2645: FROM po_line_locations_all

2641: x_return_status := 'N';
2642:
2643: IF(p_line_loc_id IS NOT NULL) THEN
2644: SELECT po_header_id INTO l_header_id
2645: FROM po_line_locations_all
2646: WHERE line_location_id = p_line_loc_id;
2647:
2648: --Call the PO API to check whether the passed PO is complex work order.
2649: IF (po_complex_work_pvt.is_complex_work_po(l_header_id)) THEN

Line 2874: po_line_locations_all plla,

2870: l_receipt_required_flag
2871: FROM
2872: po_headers_all pha,
2873: po_lines_all pla,
2874: po_line_locations_all plla,
2875: po_requisition_lines_all prla
2876: WHERE
2877: prla.requisition_line_id = p_req_line_id
2878: AND prla.line_location_id = plla.line_location_id

Line 3014: FROM po_line_locations_all plla

3010: BEGIN
3011:
3012: SELECT 1
3013: INTO l_not_delivered
3014: FROM po_line_locations_all plla
3015: WHERE
3016: plla.line_location_id = l_po_line_loc_id AND
3017: ((nvl(plla.quantity_received, 0) >
3018: (SELECT SUM(nvl(pod.quantity_delivered, 0))

Line 3054: po_line_locations_all poll,

3050:
3051: SELECT 1
3052: INTO l_dist_not_valid
3053: FROM
3054: po_line_locations_all poll,
3055: po_distributions_all pod,
3056: gl_code_combinations gcc
3057: WHERE
3058: poll.line_location_id = l_po_line_loc_id AND

Line 3207: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%TYPE;

3203: l_closed_code po_headers_all.closed_code%TYPE;
3204: l_cancel_flag po_headers_all.cancel_flag%TYPE;
3205: l_catalog_type po_requisition_lines_all.catalog_type%TYPE;
3206: l_allow_price_override_flag po_lines_all.allow_price_override_flag%TYPE;
3207: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%TYPE;
3208: l_qty_received NUMBER;
3209: l_qty_billed NUMBER;
3210: l_count NUMBER;
3211: l_release_id NUMBER;

Line 3436: FROM po_line_locations_all

3432: */
3433: IF(l_line_changeable_flag = 'Y') THEN
3434:
3435: SELECT po_release_id INTO l_release_id
3436: FROM po_line_locations_all
3437: WHERE line_location_id = l_line_loc_id;
3438:
3439: IF(l_release_id IS NULL) THEN
3440:

Line 3463: po_line_locations_all plla,

3459: l_frozen_flag
3460: FROM
3461: po_headers_all pha,
3462: po_lines_all pla,
3463: po_line_locations_all plla,
3464: po_requisition_lines_all prla
3465: WHERE pha.po_header_id = plla.po_header_id
3466: AND pla.po_line_id = plla.po_line_id
3467: AND plla.line_location_id = prla.line_location_id

Line 3492: po_line_locations_all plla,

3488: l_qty_billed,
3489: l_frozen_flag
3490: FROM
3491: po_lines_all pla,
3492: po_line_locations_all plla,
3493: po_requisition_lines_all prla,
3494: po_releases_all pra
3495: WHERE pla.po_line_id = plla.po_line_id
3496: AND plla.line_location_id = prla.line_location_id

Line 3571: po_line_locations_all plla,

3567: SELECT COUNT(1)
3568: INTO l_count
3569: FROM
3570: po_requisition_lines_all prla,
3571: po_line_locations_all plla,
3572: po_line_locations_all plla2
3573: WHERE plla.line_location_id = prla.line_location_id
3574: AND prla.requisition_line_id = p_req_line_id
3575: AND plla2.po_line_id = plla.po_line_id;

Line 3572: po_line_locations_all plla2

3568: INTO l_count
3569: FROM
3570: po_requisition_lines_all prla,
3571: po_line_locations_all plla,
3572: po_line_locations_all plla2
3573: WHERE plla.line_location_id = prla.line_location_id
3574: AND prla.requisition_line_id = p_req_line_id
3575: AND plla2.po_line_id = plla.po_line_id;
3576:

Line 3912: FROM po_line_locations_all

3908: po_header_id
3909: INTO
3910: l_po_release_id,
3911: l_po_header_id
3912: FROM po_line_locations_all
3913: WHERE line_location_id = l_line_loc_id;
3914: IF(l_po_release_id IS NULL) THEN
3915: SELECT revision_num, segment1 INTO
3916: l_po_revision_num, l_po_num

Line 4089: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;

4085: l_cancel_errtable po_req_change_err_table;
4086: l_cal_disttax_status VARCHAR2(1);
4087: l_item_id NUMBER;
4088: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;
4089: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
4090: l_po_to_req_rate NUMBER;
4091:
4092: l_po_return_code VARCHAR2(100) := '';
4093: l_err_line_id_tbl po_tbl_number;

Line 4202: po_line_locations_all plla

4198: po_change_requests pcr,
4199: po_req_distributions_all prda,
4200: po_distributions_all pda,
4201: po_requisition_lines_all prla,
4202: po_line_locations_all plla
4203: WHERE
4204: pcr.change_request_group_id = grp_id AND
4205: (pcr.new_quantity IS NOT NULL OR pcr.new_amount IS NOT NULL) AND
4206: pcr.action_type = 'MODIFICATION' AND

Line 4220: po_line_locations_all plla

4216: po_change_requests pcr,
4217: po_requisition_lines_all prla,
4218: po_req_distributions_all prda,
4219: po_distributions_all pda,
4220: po_line_locations_all plla
4221: WHERE
4222: pcr.change_request_group_id = grp_id AND
4223: pcr.action_type = 'MODIFICATION' AND
4224: (pcr.new_price IS NOT NULL OR pcr.new_need_by_date IS NOT NULL) AND

Line 4393: po_line_locations_all plla,

4389: l_ship_to_loc_id
4390: FROM
4391: po_req_distributions_all prda,
4392: po_requisition_lines_all prla,
4393: po_line_locations_all plla,
4394: po_distributions_all pda,
4395: po_lines_all pla,
4396: po_headers_all pha
4397: WHERE

Line 5289: from po_line_locations_all

5285: po_header_id
5286: into
5287: l_po_release_id,
5288: l_po_header_id
5289: from po_line_locations_all
5290: where line_location_id = l_line_loc_id;
5291: if(l_po_release_id is null) then
5292: select revision_num,segment1 into
5293: l_po_revision_num, l_po_num

Line 6214: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;

6210: l_cancel_errtable po_req_change_err_table;
6211: l_cal_disttax_status VARCHAR2(1);
6212: l_item_id NUMBER;
6213: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;
6214: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
6215: l_po_to_req_rate NUMBER;
6216:
6217: l_po_return_code VARCHAR2(100) := '';
6218: l_err_line_id_tbl po_tbl_number;