[Home] [Help]
1122: poh.currency_code,
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
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
2973: where pcr.change_request_group_id=l_change_request_group_id
2974: and pcr.request_status='MGR_APP'
2975: and pcr.document_distribution_id is null
2976: and pcr.document_line_id=prl.requisition_line_id
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
3028: where pcr.change_request_group_id=l_change_request_group_id
3029: and pcr.request_status='MGR_APP'
3030: and pcr.document_distribution_id is null
3031: and pcr.document_line_id=prl.requisition_line_id
3080: po_headers_all poh,
3081: po_releases_all por,
3082: po_distributions_all pod,
3083: po_req_distributions_all prd,
3084: po_lines_all pol
3085: where pcr.change_request_group_id=l_change_request_group_id
3086: and pcr.request_status='MGR_APP'
3087: and pcr.document_distribution_id is not null
3088: and pcr.document_line_id=prl.requisition_line_id
9354: pcr.action_type,
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
10397: SELECT 'N'
10398: FROM
10399: po_change_requests pcr, -- for quantity/amount change
10400: po_change_requests pcr1, -- for unit price change
10401: po_lines_all pl,
10402: po_distributions_all pod
10403: WHERE pl.po_line_id = pod.po_line_id
10404: AND pcr.change_request_group_id = p_pochggrp_id
10405: AND pcr.action_type(+) = 'MODIFICATION'
10474:
10475: cursor l_line_info_csr is
10476: select distinct pcr.document_line_id, document_type
10477: from po_change_requests pcr,
10478: po_lines_all pol
10479: where change_request_group_id = p_pochggrp_id
10480: and pol.po_line_id = pcr.document_line_id
10481: and action_type <> 'DERIVED'
10482: and request_status not in ('ACCEPTED', 'REJECTED')
10682: FROM
10683: po_change_requests pcr,
10684: po_change_requests pcr1,
10685: po_change_requests pcr2,
10686: po_lines_all pl,
10687: po_distributions_all pod
10688: WHERE pl.po_line_id = pod.po_line_id
10689: AND pcr.change_request_group_id(+) = p_pochggrp_id
10690: AND pcr.action_type(+) = 'MODIFICATION'
10720:
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
11158: ( nvl(pll.amount,0)-nvl(pll.amount_cancelled,0) ),
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
11174: l_progress := '001';
11175:
11176: select matching_basis,org_id,item_id,unit_price
11177: into l_po_matching_basis,l_po_org_id,l_item_id,l_unit_price
11178: from po_lines_all
11179: where po_line_id = p_po_line_id;
11180:
11181: l_progress := '002';
11182:
11186: ( nvl(pll.quantity,0)- nvl(pll.quantity_cancelled,0)) * pol.unit_price
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:
11218: exception
11219: when no_data_found then
11220: select pol.unit_price
11221: into l_new_price
11222: from po_lines_all pol
11223: where pol.po_line_id = p_po_line_id;
11224:
11225: l_pcr_new_price := null;
11226: end;
11316:
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:
11342: select decode(pol.matching_basis, 'AMOUNT',pol.amount,
11343: (nvl(pcr.new_price,pol.unit_price) * pol.quantity ))
11344: into l_new_amount
11345: from po_change_requests pcr,
11346: po_lines_all pol
11347: where pcr.change_request_group_id = p_chg_request_grp_id
11348: and pol.po_line_id = p_po_line_id
11349: and pcr.document_line_id = p_po_line_id
11350: and pcr.request_level = 'LINE'