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_REQUISITION_LINES_ALL

Line 87: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;

83: l_new_qty NUMBER;
84: l_new_po_qty NUMBER;
85: l_old_price NUMBER;
86: l_old_curr_price NUMBER;
87: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;
88: l_req_user_id NUMBER;
89: l_document_header_id NUMBER;
90: l_document_num po_change_requests.document_num%TYPE;
91: l_document_revision_num NUMBER;

Line 99: l_req_currency_code po_requisition_lines_all.currency_code%TYPE;

95: l_source_doc_header_id NUMBER;
96: l_source_doc_line_num NUMBER;
97: l_deliver_to_loc_id NUMBER;
98: l_destination_org_id NUMBER;
99: l_req_currency_code po_requisition_lines_all.currency_code%TYPE;
100: l_req_rate_type po_requisition_lines_all.rate_type%TYPE;
101: l_org_id NUMBER;
102: l_creation_date DATE;
103: l_supplier_id NUMBER;

Line 100: l_req_rate_type po_requisition_lines_all.rate_type%TYPE;

96: l_source_doc_line_num NUMBER;
97: l_deliver_to_loc_id NUMBER;
98: l_destination_org_id NUMBER;
99: l_req_currency_code po_requisition_lines_all.currency_code%TYPE;
100: l_req_rate_type po_requisition_lines_all.rate_type%TYPE;
101: l_org_id NUMBER;
102: l_creation_date DATE;
103: l_supplier_id NUMBER;
104: l_supplier_site_id NUMBER;

Line 108: l_item_revision po_requisition_lines_all.item_revision%TYPE;

104: l_supplier_site_id NUMBER;
105: l_order_header_id NUMBER;
106: l_order_line_id NUMBER;
107: l_line_type_id NUMBER;
108: l_item_revision po_requisition_lines_all.item_revision%TYPE;
109: l_item_id NUMBER;
110: l_category_id NUMBER;
111: l_supplier_item_num po_requisition_lines_all.supplier_ref_number%TYPE;
112: l_in_price NUMBER;

Line 111: l_supplier_item_num po_requisition_lines_all.supplier_ref_number%TYPE;

107: l_line_type_id NUMBER;
108: l_item_revision po_requisition_lines_all.item_revision%TYPE;
109: l_item_id NUMBER;
110: l_category_id NUMBER;
111: l_supplier_item_num po_requisition_lines_all.supplier_ref_number%TYPE;
112: l_in_price NUMBER;
113:
114: -- output values
115: l_new_base_unit_price NUMBER;

Line 119: l_currency_code po_requisition_lines_all.currency_code%TYPE;

115: l_new_base_unit_price NUMBER;
116: l_new_price NUMBER;
117: l_new_curr_price NUMBER;
118: l_discount NUMBER;
119: l_currency_code po_requisition_lines_all.currency_code%TYPE;
120: l_rate_type po_requisition_lines_all.rate_type%TYPE;
121: l_rate_date DATE;
122: l_rate NUMBER;
123: l_price_break_id NUMBER;

Line 120: l_rate_type po_requisition_lines_all.rate_type%TYPE;

116: l_new_price NUMBER;
117: l_new_curr_price NUMBER;
118: l_discount NUMBER;
119: l_currency_code po_requisition_lines_all.currency_code%TYPE;
120: l_rate_type po_requisition_lines_all.rate_type%TYPE;
121: l_rate_date DATE;
122: l_rate NUMBER;
123: l_price_break_id NUMBER;
124:

Line 135: po_requisition_lines_all prla

131: pcr.document_line_id,
132: pcr.document_line_number,
133: pcr.requester_id
134: FROM po_change_requests pcr,
135: po_requisition_lines_all prla
136: WHERE pcr.change_request_group_id = grp_id
137: AND pcr.action_type = 'MODIFICATION'
138: AND prla.requisition_line_id = pcr.document_line_id
139: AND prla.blanket_po_header_id IS NOT NULL;

Line 213: po_requisition_lines_all prla,

209: l_quantity_received,
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:

Line 400: l_matching_basis po_requisition_lines_all.matching_basis%TYPE;

396: l_req_user_id NUMBER;
397: l_req_header_id NUMBER;
398: l_req_num po_requisition_headers_all.segment1%TYPE;
399: l_requester_id NUMBER;
400: l_matching_basis po_requisition_lines_all.matching_basis%TYPE;
401: l_old_amount NUMBER;
402: l_new_amount NUMBER;
403: l_old_cur_amount NUMBER;
404: l_new_cur_amount NUMBER;

Line 449: FROM po_requisition_lines_all

445: l_progress := '001';
446:
447: SELECT matching_basis, quantity, amount, currency_amount
448: INTO l_matching_basis, l_old_quantity, l_old_amount, l_old_cur_amount
449: FROM po_requisition_lines_all
450: WHERE requisition_line_id = l_line_id;
451:
452: -- handle amount based lines
453: IF (l_matching_basis = 'AMOUNT') THEN

Line 696: po_requisition_lines_all prla,

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
699: pla.po_header_id = p_header_id
700: AND pla.po_line_id = p_po_change_table(s).document_line_id

Line 722: po_requisition_lines_all prla,

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
725: plla.po_release_id = p_release_id
726: AND plla.line_location_id = p_po_change_table(s).document_line_location_id

Line 793: po_requisition_lines_all prla,

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
796: pla.po_header_id = p_header_id
797: AND pla.po_line_id = p_po_change_table(s).document_line_id

Line 819: po_requisition_lines_all prla,

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
822: plla.po_release_id = p_release_id
823: AND plla.line_location_id = p_po_change_table(s).document_line_location_id

Line 1194: l_transaction_currency po_requisition_lines_all.currency_code%TYPE;

1190: *the new functionally currency price.
1191: */
1192: FUNCTION calculate_newunitprice(p_req_line_id NUMBER, p_new_price NUMBER) RETURN NUMBER
1193: IS
1194: l_transaction_currency po_requisition_lines_all.currency_code%TYPE;
1195: l_functional_currency gl_sets_of_books.currency_code%TYPE;
1196: l_rate_type po_requisition_lines_all.rate_type%TYPE;
1197: l_conversion_date DATE;
1198: l_rate NUMBER;

Line 1196: l_rate_type po_requisition_lines_all.rate_type%TYPE;

1192: FUNCTION calculate_newunitprice(p_req_line_id NUMBER, p_new_price NUMBER) RETURN NUMBER
1193: IS
1194: l_transaction_currency po_requisition_lines_all.currency_code%TYPE;
1195: l_functional_currency gl_sets_of_books.currency_code%TYPE;
1196: l_rate_type po_requisition_lines_all.rate_type%TYPE;
1197: l_conversion_date DATE;
1198: l_rate NUMBER;
1199: l_unit_price NUMBER;
1200: l_denominator NUMBER;

Line 1209: FROM po_requisition_lines_all

1205: BEGIN
1206:
1207: SELECT currency_code
1208: INTO l_transaction_currency
1209: FROM po_requisition_lines_all
1210: WHERE requisition_line_id = p_req_line_id ;
1211:
1212: SELECT currency_code, fsp.set_of_books_id
1213: INTO l_functional_currency, l_set_of_books_id

Line 1222: FROM po_requisition_lines_all

1218:
1219: IF(l_transaction_currency <> l_functional_currency) THEN
1220: SELECT nvl(rate_type,' ')
1221: INTO l_rate_type
1222: FROM po_requisition_lines_all
1223: WHERE requisition_line_id = p_req_line_id;
1224:
1225: IF(l_rate_type <> 'User') THEN
1226: SELECT rate_date

Line 1228: FROM po_requisition_lines_all

1224:
1225: IF(l_rate_type <> 'User') THEN
1226: SELECT rate_date
1227: INTO l_conversion_date
1228: FROM po_requisition_lines_all
1229: WHERE requisition_line_id = p_req_line_id;
1230:
1231: gl_currency_api.get_triangulation_rate(l_set_of_books_id,
1232: l_transaction_currency,

Line 1245: FROM po_requisition_lines_all

1241: (p_new_price / l_denominator) * l_numerator;
1242: ELSE
1243: SELECT rate
1244: INTO l_rate
1245: FROM po_requisition_lines_all
1246: WHERE requisition_line_id = p_req_line_id;
1247:
1248: l_unit_price := p_new_price * l_rate;
1249: END IF;

Line 1465: po_requisition_lines_all prla

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:
1469: --Refresh l_po_change_table

Line 1502: po_requisition_lines_all prla

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:
1506:

Line 1786: po_requisition_lines_all prl,

1782: l_new_total,
1783: l_rec_tax,
1784: l_nonrec_tax
1785: FROM
1786: po_requisition_lines_all prl,
1787: po_req_distributions_all prd
1788: WHERE prd.distribution_id = p_dist_id
1789: AND prd.requisition_line_id = prl.requisition_line_id;
1790:

Line 1895: FROM po_requisition_lines_all

1891: AND new_price IS NOT NULL;
1892: EXCEPTION WHEN OTHERS THEN
1893: SELECT nvl(currency_unit_price, unit_price)
1894: INTO l_price
1895: FROM po_requisition_lines_all
1896: WHERE requisition_line_id = l_line_id;
1897: END;
1898: l_progress := '001';
1899: --INNER LOOP: After getting the most recent price, update child distribution records with tax information.

Line 2060: FROM po_requisition_lines_all

2056:
2057: BEGIN
2058: SELECT nvl(currency_unit_price, unit_price)
2059: INTO l_price
2060: FROM po_requisition_lines_all
2061: WHERE requisition_line_id = l_line_id;
2062: EXCEPTION WHEN OTHERS THEN
2063: l_price := NULL;
2064: END;

Line 2157: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;

2153: l_preparer_id NUMBER;
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;

Line 2247: po_requisition_lines_all prla,

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
2250: WHERE
2251: prda.distribution_id = req_change_record_tbl(req_index).document_distribution_id

Line 2327: po_requisition_lines_all prla,

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
2331: AND prla.line_location_id = plla.line_location_id

Line 2419: po_requisition_lines_all prla,

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
2421: WHERE
2422: prda.distribution_id = req_change_record_tbl(req_index).document_distribution_id
2423: AND prda.distribution_id = pda.req_distribution_id

Line 2500: po_requisition_lines_all prla,

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
2504: AND prla.line_location_id = plla.line_location_id

Line 2738: l_auction_display_number po_requisition_lines_all.auction_display_number%TYPE;

2734: IS
2735: l_api_name VARCHAR2(50) := 'IS_REQ_LINE_CANCELLABLE';
2736: l_progress VARCHAR2(3) := '000';
2737: --bug# 13999194
2738: l_auction_display_number po_requisition_lines_all.auction_display_number%TYPE;
2739: l_auction_line_number NUMBER;
2740: l_reqs_in_pool_flag VARCHAR2(1);
2741: l_source_type_code po_requisition_lines_all.source_type_code%TYPE;
2742: l_return_status VARCHAR2(1);

Line 2741: l_source_type_code po_requisition_lines_all.source_type_code%TYPE;

2737: --bug# 13999194
2738: l_auction_display_number po_requisition_lines_all.auction_display_number%TYPE;
2739: l_auction_line_number NUMBER;
2740: l_reqs_in_pool_flag VARCHAR2(1);
2741: l_source_type_code po_requisition_lines_all.source_type_code%TYPE;
2742: l_return_status VARCHAR2(1);
2743: l_po_header_id NUMBER;
2744: l_po_release_id NUMBER;
2745: l_po_line_id NUMBER;

Line 2801: po_requisition_lines_all prla,

2797: l_modified_by_agent,
2798: l_transferred_to_oe_flag,
2799: l_cancelled
2800: FROM
2801: po_requisition_lines_all prla,
2802: po_requisition_headers_all prha
2803: WHERE
2804: prla.requisition_line_id = p_req_line_id AND
2805: prla.requisition_header_id = prha.requisition_header_id;

Line 2859: po_requisition_lines_all prla,

2855: l_po_line_loc_id,
2856: l_req_change_pending_flag,
2857: l_modified_by_agent
2858: FROM
2859: po_requisition_lines_all prla,
2860: po_requisition_headers_all prha
2861: WHERE
2862: prla.requisition_line_id = p_req_line_id AND
2863: prla.requisition_header_id = prha.requisition_header_id;

Line 2896: po_requisition_lines_all prla

2892: INTO l_count
2893: FROM
2894: po_req_distributions_all prda,
2895: po_distributions_all pda,
2896: po_requisition_lines_all prla
2897: WHERE pda.line_location_id = prla.line_location_id
2898: AND prla.requisition_line_id = p_req_line_id
2899: AND pda.req_distribution_id = prda.distribution_id(+ );
2900:

Line 2939: po_requisition_lines_all prla

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
2943: AND plla.po_line_id = pla.po_line_id

Line 3261: l_source_type_code po_requisition_lines_all.source_type_code%TYPE;

3257: l_api_name VARCHAR2(50) := 'IS_REQ_LINE_CHANGEABLE';
3258: l_progress VARCHAR2(100) := '000';
3259: l_line_changeable_flag VARCHAR2(1);
3260: l_line_loc_id NUMBER;
3261: l_source_type_code po_requisition_lines_all.source_type_code%TYPE;
3262: l_auction_display_number po_requisition_lines_all.auction_display_number%TYPE;
3263: l_auction_line_number NUMBER;
3264: l_reqs_in_pool_flag po_requisition_lines_all.reqs_in_pool_flag%TYPE;
3265: l_authorization_status po_headers_all.authorization_status%TYPE;

Line 3262: l_auction_display_number po_requisition_lines_all.auction_display_number%TYPE;

3258: l_progress VARCHAR2(100) := '000';
3259: l_line_changeable_flag VARCHAR2(1);
3260: l_line_loc_id NUMBER;
3261: l_source_type_code po_requisition_lines_all.source_type_code%TYPE;
3262: l_auction_display_number po_requisition_lines_all.auction_display_number%TYPE;
3263: l_auction_line_number NUMBER;
3264: l_reqs_in_pool_flag po_requisition_lines_all.reqs_in_pool_flag%TYPE;
3265: l_authorization_status po_headers_all.authorization_status%TYPE;
3266: l_frozen_flag VARCHAR2(1);

Line 3264: l_reqs_in_pool_flag po_requisition_lines_all.reqs_in_pool_flag%TYPE;

3260: l_line_loc_id NUMBER;
3261: l_source_type_code po_requisition_lines_all.source_type_code%TYPE;
3262: l_auction_display_number po_requisition_lines_all.auction_display_number%TYPE;
3263: l_auction_line_number NUMBER;
3264: l_reqs_in_pool_flag po_requisition_lines_all.reqs_in_pool_flag%TYPE;
3265: l_authorization_status po_headers_all.authorization_status%TYPE;
3266: l_frozen_flag VARCHAR2(1);
3267: l_closed_code po_headers_all.closed_code%TYPE;
3268: l_cancel_flag po_headers_all.cancel_flag%TYPE;

Line 3269: l_catalog_type po_requisition_lines_all.catalog_type%TYPE;

3265: l_authorization_status po_headers_all.authorization_status%TYPE;
3266: l_frozen_flag VARCHAR2(1);
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;

Line 3279: l_order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE ;

3275: l_release_id NUMBER;
3276: l_return_status VARCHAR2(1);
3277: l_line_type po_line_types.purchase_basis%TYPE;
3278: l_global_agreement_flag po_headers_all.global_agreement_flag%TYPE;
3279: l_order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE ;
3280: l_po_header_id po_headers_all.po_header_id%TYPE;
3281: l_template_id po_requisition_lines_all.noncat_template_id%TYPE;
3282: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;
3283: l_amount_editable_flag por_noncat_templates_all_b.amount_editable_flag%TYPE;

Line 3281: l_template_id po_requisition_lines_all.noncat_template_id%TYPE;

3277: l_line_type po_line_types.purchase_basis%TYPE;
3278: l_global_agreement_flag po_headers_all.global_agreement_flag%TYPE;
3279: l_order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE ;
3280: l_po_header_id po_headers_all.po_header_id%TYPE;
3281: l_template_id po_requisition_lines_all.noncat_template_id%TYPE;
3282: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;
3283: l_amount_editable_flag por_noncat_templates_all_b.amount_editable_flag%TYPE;
3284: -- added for retroactive pricing checks
3285: l_retropricing VARCHAR2(20) := '';

Line 3287: l_destination_type_code po_requisition_lines_all.destination_type_code%TYPE;

3283: l_amount_editable_flag por_noncat_templates_all_b.amount_editable_flag%TYPE;
3284: -- added for retroactive pricing checks
3285: l_retropricing VARCHAR2(20) := '';
3286: l_amount_based_service_line BOOLEAN := FALSE;
3287: l_destination_type_code po_requisition_lines_all.destination_type_code%TYPE;
3288: l_is_on_complex_work_po VARCHAR2(1);
3289: l_transferred_to_oe_flag varchar2(1);
3290: l_price_updateable varchar2(1);
3291: BEGIN

Line 3331: po_requisition_lines_all prla,

3327: l_template_id,
3328: l_destination_type_code,
3329: l_transferred_to_oe_flag
3330: FROM
3331: po_requisition_lines_all prla,
3332: po_requisition_headers_all prha
3333: WHERE
3334: prla.requisition_line_id = p_req_line_id AND
3335: prla.requisition_header_id = prha.requisition_header_id;

Line 3393: FROM po_requisition_lines_all

3389: p_end_date_changeable_flag := 'Y';
3390:
3391: SELECT order_type_lookup_code
3392: INTO l_order_type_lookup_code
3393: FROM po_requisition_lines_all
3394: WHERE requisition_line_id = p_req_line_id;
3395:
3396: IF (l_line_type = 'SERVICES') THEN
3397: p_date_changeable_flag := 'Y';

Line 3424: po_requisition_lines_all prla

3420:
3421: SELECT pha.global_agreement_flag, pha.po_header_id
3422: INTO l_global_agreement_flag, l_po_header_id
3423: FROM po_headers_all pha,
3424: po_requisition_lines_all prla
3425: WHERE pha.po_header_id (+ ) = prla.blanket_po_header_id
3426: AND prla.requisition_line_id = p_req_line_id;
3427:
3428: IF(l_global_agreement_flag = 'Y') THEN

Line 3432: FROM po_requisition_lines_all prl,

3428: IF(l_global_agreement_flag = 'Y') THEN
3429: BEGIN
3430: SELECT pla.allow_price_override_flag
3431: INTO l_allow_price_override_flag
3432: FROM po_requisition_lines_all prl,
3433: po_headers_all pha,
3434: po_lines_all pla
3435: WHERE pha.po_header_id = l_po_header_id
3436: AND pla.po_header_id = pha.po_header_id

Line 3535: po_requisition_lines_all prla

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
3539: AND prla.requisition_line_id = p_req_line_id;

Line 3564: po_requisition_lines_all prla,

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
3568: AND prla.requisition_line_id = p_req_line_id

Line 3578: po_requisition_lines_all prla

3574: --Bug:16423039 Consider the override flag on GBPA/BPA in RCO,NOT SPO/BPA Release
3575: SELECT DECODE(prla.document_type_code,'BLANKET',NVL(pla.allow_price_override_flag, 'N'),'Y')
3576: INTO l_allow_price_override_flag
3577: FROM po_lines_all pla,
3578: po_requisition_lines_all prla
3579: WHERE pla.line_num(+) = prla.blanket_po_line_num
3580: AND pla.po_header_id(+) = prla.blanket_po_header_id
3581: and prla.requisition_line_id = p_req_line_id;
3582:

Line 3622: po_requisition_lines_all prla

3618: INTO l_count
3619: FROM
3620: po_req_distributions_all prda,
3621: po_distributions_all pda,
3622: po_requisition_lines_all prla
3623: WHERE pda.line_location_id = prla.line_location_id
3624: AND prla.requisition_line_id = p_req_line_id
3625: AND pda.req_distribution_id = prda.distribution_id(+ );
3626:

Line 3651: po_requisition_lines_all prla,

3647: l_progress := '005';
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

Line 3982: po_requisition_lines_all prla

3978: l_req_date,
3979: l_req_currency_price
3980: FROM
3981: po_requisition_headers_all prha,
3982: po_requisition_lines_all prla
3983: WHERE prla.requisition_line_id = p_cancel_table.req_line_id(i)
3984: AND prla.requisition_header_id = prha.requisition_header_id;
3985:
3986: IF(l_line_loc_id IS NOT NULL) THEN

Line 4171: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;

4167: l_request_reason po_change_requests.request_reason%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) := '';

Line 4229: po_requisition_lines_all prla,

4225: prla.requisition_header_id hdr_id,
4226: prha.segment1 req_num
4227: FROM
4228: po_req_distributions_all prda,
4229: po_requisition_lines_all prla,
4230: po_change_requests pcr,
4231: po_requisition_headers_all prha
4232: WHERE
4233: prha.requisition_header_id = prla.requisition_header_id AND

Line 4262: po_requisition_lines_all prla,

4258: SELECT -- select distributions that are effected with any line change
4259: pda.po_distribution_id
4260: FROM
4261: po_change_requests pcr,
4262: po_requisition_lines_all prla,
4263: po_req_distributions_all prda,
4264: po_distributions_all pda,
4265: po_headers_all pha
4266: WHERE

Line 4284: po_requisition_lines_all prla,

4280: FROM
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

Line 4300: po_requisition_lines_all prla,

4296: SELECT
4297: pda.po_distribution_id
4298: FROM
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

Line 4475: po_requisition_lines_all prla,

4471: l_ship_to_org_id,
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

Line 4728: po_requisition_lines_all prla,

4724: l_fc_req_distr_num,
4725: l_fc_req_line_id,
4726: l_fc_req_line_num
4727: FROM
4728: po_requisition_lines_all prla,
4729: po_req_distributions_all prda,
4730: po_distributions_all pda
4731: WHERE
4732: pda.po_distribution_id = l_fc_out_tbl.distribution_id(x)

Line 4896: po_requisition_lines_all prla

4892: prla.line_location_id,
4893: pcr.change_request_id
4894: FROM
4895: po_change_requests pcr,
4896: po_requisition_lines_all prla
4897: WHERE pcr.action_type = 'CANCELLATION'
4898: AND pcr.change_request_group_id = grp_id
4899: AND pcr.document_line_id = prla.requisition_line_id;
4900: BEGIN

Line 5284: FROM po_requisition_lines_all prl

5280: prl.requisition_header_id
5281: INTO
5282: l_req_line_id,
5283: l_req_header_id
5284: FROM po_requisition_lines_all prl
5285: WHERE prl.requisition_line_id = p_req_line_id;
5286:
5287: l_progress := '001';
5288:

Line 5436: po_requisition_lines_all prla

5432: l_req_quantity,
5433: l_req_date
5434: FROM
5435: po_requisition_headers_all prha,
5436: po_requisition_lines_all prla
5437: WHERE prla.requisition_line_id = p_cancel_table.req_line_id(i)
5438: AND prla.requisition_header_id = prha.requisition_header_id;
5439:
5440: /* if(l_line_loc_id is not null) then

Line 5667: po_requisition_lines_all prla,

5663: l_old_req_quantity,
5664: l_old_amount,
5665: l_preparer_id
5666: FROM
5667: po_requisition_lines_all prla,
5668: po_requisition_headers_all prha,
5669: po_req_distributions_all prda
5670: WHERE
5671: prha.requisition_header_id = p_req_hdr_id

Line 5861: po_requisition_lines_all prla

5857: prla.line_location_id,
5858: pcr.change_request_id
5859: FROM
5860: po_change_requests pcr,
5861: po_requisition_lines_all prla
5862: WHERE pcr.action_type = 'CANCELLATION'
5863: AND pcr.change_request_group_id = grp_id
5864: AND pcr.document_line_id = prla.requisition_line_id;
5865: BEGIN

Line 6056: FROM po_requisition_lines_all

6052:
6053: BEGIN
6054: SELECT QUANTITY, nvl(QUANTITY_DELIVERED,0)
6055: INTO l_quantity, l_quantity_delivered
6056: FROM po_requisition_lines_all
6057: WHERE REQUISITION_LINE_ID=p_req_line_id;
6058: EXCEPTION
6059: WHEN OTHERS THEN
6060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6155: -- this is applicable to both mtl_supply and po_requisition_lines_all

6151: --algo
6152: -- for the given req line the given attribute needs to be chnaged
6153: -- for quantity .. input is the delta qunatity = new qunatity-old quantity
6154: -- hence the new line quantity shall be existing qunatity+delta quantity
6155: -- this is applicable to both mtl_supply and po_requisition_lines_all
6156:
6157: -- for need by date.. input is new need by date so update this value to
6158: -- both the tables
6159: IF p_req_line_id IS NOT NULL AND p_delta_quantity IS NOT NULL THEN

Line 6264: l_req_uom po_requisition_lines_all.unit_meas_lookup_code%TYPE;

6260: l_request_reason po_change_requests.request_reason%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) := '';

Line 6321: po_requisition_lines_all prla,

6317: prla.requisition_header_id hdr_id,
6318: prha.segment1 req_num
6319: FROM
6320: po_req_distributions_all prda,
6321: po_requisition_lines_all prla,
6322: po_change_requests pcr,
6323: po_requisition_headers_all prha
6324: WHERE
6325: prha.requisition_header_id = prla.requisition_header_id AND

Line 6361: po_requisition_lines_all prla,

6357: SELECT -- select distributions that are effected with any line change
6358: prda.distribution_id
6359: FROM
6360: po_change_requests pcr,
6361: po_requisition_lines_all prla,
6362: po_req_distributions_all prda
6363: WHERE
6364: pcr.change_request_group_id = grp_id AND
6365: pcr.action_type = 'MODIFICATION' AND

Line 6381: po_requisition_lines_all prla

6377: nvl(pcr.new_quantity, pcr.old_quantity)
6378: FROM
6379: po_change_requests pcr,
6380: po_req_distributions_all prda,
6381: po_requisition_lines_all prla
6382: WHERE
6383: pcr.change_request_group_id = grp_id AND
6384: pcr.new_quantity IS NOT NULL AND
6385: -- (pcr.new_quantity IS NOT NULL OR pcr.new_need_by_date IS NOT NULL) AND

Line 6647: po_requisition_lines_all prla,

6643: l_fc_req_distr_num,
6644: l_fc_req_line_id,
6645: l_fc_req_line_num
6646: FROM
6647: po_requisition_lines_all prla,
6648: po_req_distributions_all prda,
6649: po_distributions_all pda
6650: WHERE
6651: pda.po_distribution_id = l_fc_out_tbl.distribution_id(x)

Line 6809: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE

6805: l_progress varchar2(3) := '000';
6806:
6807: /*Procedure Call_Process_Order_for_IReq -- Specification definition
6808: ( P_API_Version IN NUMBER
6809: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
6810: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
6811: , P_Mode IN VARCHAR2
6812: , P_Cancel_ISO IN BOOLEAN DEFAULT FALSE
6813: , P_Cancel_ISO_lines IN BOOLEAN DEFAULT FALSE

Line 6837: ,po_requisition_lines_all pol

6833: INTO l_open_quantity
6834: FROM oe_order_lines_all oel
6835: ,oe_order_headers_all oeh
6836: ,wsh_delivery_details w
6837: ,po_requisition_lines_all pol
6838: ,po_requisition_headers_all poh --Bug 14280643
6839: WHERE
6840: oel.header_id = oeh.header_id
6841: AND oel.line_id = w.source_line_id

Line 7037: FROM po_requisition_lines_all

7033:
7034: BEGIN
7035: SELECT QUANTITY, SECONDARY_QUANTITY
7036: INTO l_prim_quantity, l_sec_quantity
7037: FROM po_requisition_lines_all
7038: WHERE REQUISITION_LINE_ID=p_req_line_id;
7039: EXCEPTION
7040: WHEN OTHERS THEN
7041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7154: -- this is applicable to both mtl_supply and po_requisition_lines_all

7150: --algo
7151: -- for the given req line the given attribute needs to be chnaged
7152: -- for quantity .. input is the delta qunatity = new qunatity-old quantity
7153: -- hence the new line quantity shall be existing qunatity+delta quantity
7154: -- this is applicable to both mtl_supply and po_requisition_lines_all
7155:
7156: -- for need by date.. input is new need by date so update this value to
7157: -- both the tables
7158: IF p_req_line_id IS NOT NULL AND (p_delta_quantity_prim IS NOT NULL OR p_delta_quantity_sec IS NOT NULL )THEN

Line 7214: SELECT REQUISITION_LINE_ID FROM po_requisition_lines_all where REQUISITION_HEADER_ID = req_hdr_id;

7210: PROCEDURE del_req_line_chng_attachments(p_req_hdr_id IN NUMBER,
7211: x_return_status OUT NOCOPY VARCHAR2)
7212: IS
7213: CURSOR l_req_lines_csr(req_hdr_id NUMBER) IS
7214: SELECT REQUISITION_LINE_ID FROM po_requisition_lines_all where REQUISITION_HEADER_ID = req_hdr_id;
7215: l_req_line_id NUMBER;
7216: BEGIN
7217: OPEN l_req_lines_csr(p_req_hdr_id);
7218: LOOP