[Home] [Help]
1123: pol.org_id
1124: from po_change_requests pcr,
1125: po_headers_all poh,
1126: po_lines_all pol,
1127: po_line_locations_all pll,
1128: po_distributions_all pod,
1129: po_releases_all por
1130: where pcr.change_request_group_id=p_change_request_group_id
1131: and pcr.request_status='PENDING'
1831:
1832: -- when change request is rejected,
1833: -- set po shipments approved_flag column value to 'Y'
1834: -- since when change request is submitted, it is set to 'R'
1835: UPDATE po_line_locations_all
1836: SET
1837: approved_flag = 'Y',
1838: last_update_date = sysdate,
1839: last_updated_by = fnd_global.user_id,
1907:
1908: if (l_document_type <> 'RELEASE') then
1909: select count(1)
1910: into l_num_of_shipments
1911: from po_line_locations_all
1912: where po_line_id = l_document_line_id
1913: and nvl(cancel_flag, 'N') = 'N';
1914:
1915: if (l_num_of_shipments = 1) then
2891: l_new_ship_quantity number;
2892: l_old_ship_quantity number;
2893: l_item_id number;
2894: l_req_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%TYPE;
2895: l_po_uom po_line_locations_all.UNIT_MEAS_LOOKUP_CODE%TYPE;
2896: l_old_amount number;
2897: l_new_amount number;
2898: l_old_start_date date;
2899: l_new_start_date date;
2964: to_number(null) dist_amount,
2965: max(prl.matching_basis),
2966: max(pcr.requester_id) requester_id -- Bug # 3862383
2967: from po_change_requests pcr,
2968: po_line_locations_all pll,
2969: po_requisition_lines_all prl,
2970: po_headers_all poh,
2971: po_releases_all por,
2972: po_lines_all pol
3019: to_number(null) dist_amount,
3020: prl.matching_basis,
3021: pcr.requester_id requester_id -- Bug # 3862383
3022: from po_change_requests pcr,
3023: po_line_locations_all pll,
3024: po_requisition_lines_all prl,
3025: po_headers_all poh,
3026: po_releases_all por,
3027: po_lines_all pol
3074: pod.amount_ordered dist_amount,
3075: prl.matching_basis,
3076: pcr.requester_id requester_id -- Bug # 3862383
3077: from po_change_requests pcr,
3078: po_line_locations_all pll,
3079: po_requisition_lines_all prl,
3080: po_headers_all poh,
3081: po_releases_all por,
3082: po_distributions_all pod,
3911: where po_header_id = p_document_id;
3912:
3913: x_progress := '002';
3914:
3915: UPDATE po_line_locations_all
3916: SET
3917: approved_flag='R',
3918: last_update_date = sysdate,
3919: last_updated_by = fnd_global.user_id,
3970: where po_release_id = p_document_id;
3971:
3972: x_progress := '002';
3973:
3974: UPDATE po_line_locations_all
3975: SET
3976: approved_flag = 'R',
3977: last_update_date = sysdate,
3978: last_updated_by = fnd_global.user_id,
9355: pol.item_id,
9356: pll.unit_meas_lookup_code,
9357: pol.unit_price
9358: FROM po_change_requests pcr, po_lines_all pol,
9359: po_line_locations_all pll
9360: WHERE pcr.change_request_group_id= p_change_request_group_id
9361: AND pcr.request_status IN ('PENDING', 'ACCEPTED')
9362: AND pcr.document_header_id=pol.po_header_id
9363: AND pcr.document_line_id=pol.po_line_id
10721: into l_old_amount_release, l_new_amount_release
10722:
10723: FROM po_change_requests pcr,
10724: po_lines_all pol,
10725: po_line_locations_all pll
10726: WHERE pcr.change_request_group_id= p_pochggrp_id
10727: AND pcr.po_release_id = p_poheader_id
10728: AND pcr.document_line_id = pol.po_line_id
10729: AND pcr.request_status NOT IN ('ACCEPTED', 'REJECTED')
11159: ( nvl(pll.quantity,0)- nvl(pll.quantity_cancelled,0)) * pol.unit_price
11160: )
11161: from po_change_requests,
11162: po_lines_all pol,
11163: po_line_locations_all pll
11164: where change_request_group_id = p_chg_request_grp_id
11165: and document_line_id = p_po_line_id
11166: and document_line_location_id = pll.line_location_id
11167: and pol.po_line_id = document_line_id
11187: )
11188: )
11189: into l_old_amount
11190: FROM po_lines_all pol,
11191: po_line_locations_all pll
11192: WHERE pol.po_line_id = p_po_line_id
11193: AND pol.po_line_id = pll.po_line_id;
11194:
11195: l_progress := '003';
11250: begin
11251: select (pcr.new_amount - pll.amount)
11252: into l_shipmt_amt_increase
11253: from po_change_requests pcr,
11254: po_line_locations_all pll
11255: where pcr.change_request_group_id = p_chg_request_grp_id
11256: and pcr.document_line_location_id = l_pcr_line_loc_id
11257: and pll.line_location_id = l_pcr_line_loc_id
11258: and pcr.request_level = 'SHIPMENT'
11274: begin
11275: SELECT pcr.new_quantity,pcr.new_quantity,pll.unit_meas_lookup_code,pll.price_override
11276: into l_pcr_new_quantity,l_new_quantity,l_unit_lookup_code,l_price_override
11277: FROM po_change_requests pcr,
11278: po_line_locations_all pll
11279: WHERE pcr.change_request_group_id = p_chg_request_grp_id
11280: AND pcr.document_line_location_id = l_pcr_line_loc_id
11281: AND pll.line_location_id = l_pcr_line_loc_id
11282: AND pcr.action_type(+) = 'MODIFICATION'
11285: AND pcr.request_level = 'SHIPMENT'
11286: AND pcr.new_quantity is not null;
11287:
11288: exception
11289: -- if no qty change, we get the qty from po_line_locations_all.
11290: when no_data_found then
11291: select (pll.quantity - pll.quantity_cancelled)
11292: into l_new_quantity
11293: from po_line_locations_all pll
11289: -- if no qty change, we get the qty from po_line_locations_all.
11290: when no_data_found then
11291: select (pll.quantity - pll.quantity_cancelled)
11292: into l_new_quantity
11293: from po_line_locations_all pll
11294: where pll.line_location_id = l_pcr_line_loc_id;
11295:
11296: l_pcr_new_quantity := null;
11297:
11317: select ( (l_new_price * l_new_quantity) -
11318: nvl(pll.price_override,pol.unit_price) * pll.quantity )
11319: into l_shipmt_amt_increase
11320: from po_lines_all pol,
11321: po_line_locations_all pll
11322: where pll.line_location_id = l_pcr_line_loc_id
11323: and pol.po_line_id = pll.po_line_id ;
11324:
11325: end if;