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_RCO_VALIDATION_PVT dependencies on PO_LINE_LOCATIONS

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 1309: FROM po_line_locations_all

1305: INTO l_ship_quantity,
1306: l_ship_to_location_id,
1307: l_ship_to_organization_id,
1308: l_need_by_date
1309: FROM po_line_locations_all
1310: WHERE line_location_id = p_po_change_table(i).document_line_location_id;
1311:
1312: 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);
1313: p_po_change_table(l_po_tbl_index) := po_chg_request_pvt.create_pos_change_rec(

Line 1464: po_line_locations_all plla,

1460: INTO
1461: l_current_hdr_id,
1462: l_current_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(l_current_row_id).document_line_id;
1468:

Line 1501: po_line_locations_all plla,

1497: INTO
1498: l_hdr_id,
1499: l_rel_id
1500: FROM
1501: po_line_locations_all plla,
1502: po_requisition_lines_all prla
1503: WHERE prla.line_location_id = plla.line_location_id
1504: AND prla.requisition_line_id = p_req_change_table(i).document_line_id;
1505:

Line 2158: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;

2154: l_po_ship_to_loc_id NUMBER;
2155: l_po_ship_to_org_id NUMBER;
2156: l_item_id NUMBER;
2157: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;
2158: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
2159: l_po_to_req_rate NUMBER;
2160: l_release_num NUMBER;
2161: l_old_start_date DATE;
2162: l_old_end_date DATE;

Line 2245: po_line_locations_all plla,

2241: l_old_po_amount
2242: FROM
2243: po_headers_all pha,
2244: po_lines_all pla,
2245: po_line_locations_all plla,
2246: po_req_distributions_all prda,
2247: po_requisition_lines_all prla,
2248: po_requisition_headers_all prha,
2249: po_distributions_all pda

Line 2326: po_line_locations_all plla,

2322: l_old_po_amount
2323: FROM
2324: po_headers_all pha,
2325: po_lines_all pla,
2326: po_line_locations_all plla,
2327: po_requisition_lines_all prla,
2328: po_requisition_headers_all prha
2329: WHERE
2330: prla.requisition_line_id = req_change_record_tbl(req_index).document_line_id

Line 2416: po_line_locations_all plla,

2412: FROM
2413: po_headers_all pha,
2414: po_releases_all pra,
2415: po_lines_all pla,
2416: po_line_locations_all plla,
2417: po_distributions_all pda,
2418: po_req_distributions_all prda,
2419: po_requisition_lines_all prla,
2420: po_requisition_headers_all prha

Line 2499: po_line_locations_all plla,

2495: FROM
2496: po_headers_all pha,
2497: po_releases_all pra,
2498: po_lines_all pla,
2499: po_line_locations_all plla,
2500: po_requisition_lines_all prla,
2501: po_requisition_headers_all prha
2502: WHERE
2503: prla.requisition_line_id = req_change_record_tbl(req_index).document_line_id

Line 2674: l_header_id po_line_locations_all.po_header_id%TYPE;

2670: ----------------------------------------------------------------*/
2671: PROCEDURE is_on_complex_work_order(p_line_loc_id IN NUMBER,
2672: x_return_status OUT NOCOPY VARCHAR2)
2673: IS
2674: l_header_id po_line_locations_all.po_header_id%TYPE;
2675: l_api_name VARCHAR2(100) := 'is_on_complex_work_order()';
2676: BEGIN
2677:
2678: x_return_status := 'N';

Line 2682: FROM po_line_locations_all

2678: x_return_status := 'N';
2679:
2680: IF(p_line_loc_id IS NOT NULL) THEN
2681: SELECT po_header_id INTO l_header_id
2682: FROM po_line_locations_all
2683: WHERE line_location_id = p_line_loc_id;
2684:
2685: --Call the PO API to check whether the passed PO is complex work order.
2686: IF (po_complex_work_pvt.is_complex_work_po(l_header_id)) THEN

Line 2761: l_receipt_required_flag po_line_locations.receipt_required_flag%TYPE;

2757: l_billed_quantity NUMBER;
2758: l_amount NUMBER;
2759: l_received_amount NUMBER;
2760: l_billed_amount NUMBER;
2761: l_receipt_required_flag po_line_locations.receipt_required_flag%TYPE;
2762: l_rcv_transaction_exist NUMBER := 0;
2763: l_asn_exist NUMBER := 0;
2764: l_not_delivered NUMBER := 0;
2765: l_dist_not_valid NUMBER := 0;

Line 2938: po_line_locations_all plla,

2934: l_receipt_required_flag
2935: FROM
2936: po_headers_all pha,
2937: po_lines_all pla,
2938: po_line_locations_all plla,
2939: po_requisition_lines_all prla
2940: WHERE
2941: prla.requisition_line_id = p_req_line_id
2942: AND prla.line_location_id = plla.line_location_id

Line 3078: FROM po_line_locations_all plla

3074: BEGIN
3075:
3076: SELECT 1
3077: INTO l_not_delivered
3078: FROM po_line_locations_all plla
3079: WHERE
3080: plla.line_location_id = l_po_line_loc_id AND
3081: ((nvl(plla.quantity_received, 0) >
3082: (SELECT SUM(nvl(pod.quantity_delivered, 0))

Line 3118: po_line_locations_all poll,

3114:
3115: SELECT 1
3116: INTO l_dist_not_valid
3117: FROM
3118: po_line_locations_all poll,
3119: po_distributions_all pod,
3120: gl_code_combinations gcc
3121: WHERE
3122: poll.line_location_id = l_po_line_loc_id AND

Line 3271: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%TYPE;

3267: l_closed_code po_headers_all.closed_code%TYPE;
3268: l_cancel_flag po_headers_all.cancel_flag%TYPE;
3269: l_catalog_type po_requisition_lines_all.catalog_type%TYPE;
3270: l_allow_price_override_flag po_lines_all.allow_price_override_flag%TYPE;
3271: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%TYPE;
3272: l_qty_received NUMBER;
3273: l_qty_billed NUMBER;
3274: l_count NUMBER;
3275: l_release_id NUMBER;

Line 3507: FROM po_line_locations_all

3503: */
3504: IF(l_line_changeable_flag = 'Y') THEN
3505:
3506: SELECT po_release_id INTO l_release_id
3507: FROM po_line_locations_all
3508: WHERE line_location_id = l_line_loc_id;
3509:
3510: IF(l_release_id IS NULL) THEN
3511:

Line 3534: po_line_locations_all plla,

3530: l_frozen_flag
3531: FROM
3532: po_headers_all pha,
3533: po_lines_all pla,
3534: po_line_locations_all plla,
3535: po_requisition_lines_all prla
3536: WHERE pha.po_header_id = plla.po_header_id
3537: AND pla.po_line_id = plla.po_line_id
3538: AND plla.line_location_id = prla.line_location_id

Line 3563: po_line_locations_all plla,

3559: l_qty_billed,
3560: l_frozen_flag
3561: FROM
3562: po_lines_all pla,
3563: po_line_locations_all plla,
3564: po_requisition_lines_all prla,
3565: po_releases_all pra
3566: WHERE pla.po_line_id = plla.po_line_id
3567: AND plla.line_location_id = prla.line_location_id

Line 3652: po_line_locations_all plla,

3648: SELECT COUNT(1)
3649: INTO l_count
3650: FROM
3651: po_requisition_lines_all prla,
3652: po_line_locations_all plla,
3653: po_line_locations_all plla2
3654: WHERE plla.line_location_id = prla.line_location_id
3655: AND prla.requisition_line_id = p_req_line_id
3656: AND plla2.po_line_id = plla.po_line_id;

Line 3653: po_line_locations_all plla2

3649: INTO l_count
3650: FROM
3651: po_requisition_lines_all prla,
3652: po_line_locations_all plla,
3653: po_line_locations_all plla2
3654: WHERE plla.line_location_id = prla.line_location_id
3655: AND prla.requisition_line_id = p_req_line_id
3656: AND plla2.po_line_id = plla.po_line_id;
3657:

Line 3993: FROM po_line_locations_all

3989: po_header_id
3990: INTO
3991: l_po_release_id,
3992: l_po_header_id
3993: FROM po_line_locations_all
3994: WHERE line_location_id = l_line_loc_id;
3995: IF(l_po_release_id IS NULL) THEN
3996: SELECT revision_num, segment1 INTO
3997: l_po_revision_num, l_po_num

Line 4172: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;

4168: l_cancel_errtable po_req_change_err_table;
4169: l_cal_disttax_status VARCHAR2(1);
4170: l_item_id NUMBER;
4171: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;
4172: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
4173: l_po_to_req_rate NUMBER;
4174:
4175: l_po_return_code VARCHAR2(100) := '';
4176: l_err_line_id_tbl po_tbl_number;

Line 4285: po_line_locations_all plla

4281: po_change_requests pcr,
4282: po_req_distributions_all prda,
4283: po_distributions_all pda,
4284: po_requisition_lines_all prla,
4285: po_line_locations_all plla
4286: WHERE
4287: pcr.change_request_group_id = grp_id AND
4288: (pcr.new_quantity IS NOT NULL OR pcr.new_amount IS NOT NULL) AND
4289: pcr.action_type = 'MODIFICATION' AND

Line 4303: po_line_locations_all plla

4299: po_change_requests pcr,
4300: po_requisition_lines_all prla,
4301: po_req_distributions_all prda,
4302: po_distributions_all pda,
4303: po_line_locations_all plla
4304: WHERE
4305: pcr.change_request_group_id = grp_id AND
4306: pcr.action_type = 'MODIFICATION' AND
4307: (pcr.new_price IS NOT NULL OR pcr.new_need_by_date IS NOT NULL) AND

Line 4476: po_line_locations_all plla,

4472: l_ship_to_loc_id
4473: FROM
4474: po_req_distributions_all prda,
4475: po_requisition_lines_all prla,
4476: po_line_locations_all plla,
4477: po_distributions_all pda,
4478: po_lines_all pla,
4479: po_headers_all pha
4480: WHERE

Line 5447: from po_line_locations_all

5443: po_header_id
5444: into
5445: l_po_release_id,
5446: l_po_header_id
5447: from po_line_locations_all
5448: where line_location_id = l_line_loc_id;
5449: if(l_po_release_id is null) then
5450: select revision_num,segment1 into
5451: l_po_revision_num, l_po_num

Line 6265: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;

6261: l_cancel_errtable po_req_change_err_table;
6262: l_cal_disttax_status VARCHAR2(1);
6263: l_item_id NUMBER;
6264: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;
6265: l_po_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
6266: l_po_to_req_rate NUMBER;
6267:
6268: l_po_return_code VARCHAR2(100) := '';
6269: l_err_line_id_tbl po_tbl_number;