[Home] [Help]
1139: poh.currency_code,
1140: pol.org_id
1141: from po_change_requests pcr,
1142: po_headers_all poh,
1143: po_lines_all pol,
1144: po_line_locations_all pll,
1145: po_distributions_all pod,
1146: po_releases_all por
1147: where pcr.change_request_group_id=p_change_request_group_id
3090: po_line_locations_all pll,
3091: po_requisition_lines_all prl,
3092: po_headers_all poh,
3093: po_releases_all por,
3094: po_lines_all pol
3095: where pcr.change_request_group_id=l_change_request_group_id
3096: and pcr.request_status='MGR_APP'
3097: and pcr.document_distribution_id is null
3098: and pcr.document_line_id=prl.requisition_line_id
3146: po_line_locations_all pll,
3147: po_requisition_lines_all prl,
3148: po_headers_all poh,
3149: po_releases_all por,
3150: po_lines_all pol
3151: where pcr.change_request_group_id=l_change_request_group_id
3152: and pcr.request_status='MGR_APP'
3153: and pcr.document_distribution_id is null
3154: and pcr.document_line_id=prl.requisition_line_id
3211: po_headers_all poh,
3212: po_releases_all por,
3213: po_distributions_all pod,
3214: po_req_distributions_all prd,
3215: po_lines_all pol
3216: where pcr.change_request_group_id=l_change_request_group_id
3217: and pcr.request_status='MGR_APP'
3218: and pcr.document_distribution_id is not null
3219: and pcr.document_line_id=prl.requisition_line_id
9741: pcr.action_type,
9742: pol.item_id,
9743: pll.unit_meas_lookup_code,
9744: pol.unit_price
9745: FROM po_change_requests pcr, po_lines_all pol,
9746: po_line_locations_all pll
9747: WHERE pcr.change_request_group_id= p_change_request_group_id
9748: AND pcr.request_status IN ('PENDING', 'ACCEPTED')
9749: AND pcr.document_header_id=pol.po_header_id
10787: SELECT 'N'
10788: FROM
10789: po_change_requests pcr, -- for quantity/amount change
10790: po_change_requests pcr1, -- for unit price change
10791: po_lines_all pl,
10792: po_distributions_all pod
10793: WHERE pl.po_line_id = pod.po_line_id
10794: AND pcr.change_request_group_id = p_pochggrp_id
10795: AND pcr.action_type(+) = 'MODIFICATION'
10864:
10865: cursor l_line_info_csr is
10866: select distinct pcr.document_line_id, document_type
10867: from po_change_requests pcr,
10868: po_lines_all pol
10869: where change_request_group_id = p_pochggrp_id
10870: and pol.po_line_id = pcr.document_line_id
10871: and action_type <> 'DERIVED'
10872: and request_status not in ('ACCEPTED', 'REJECTED')
11072: FROM
11073: po_change_requests pcr,
11074: po_change_requests pcr1,
11075: po_change_requests pcr2,
11076: po_lines_all pl,
11077: po_distributions_all pod
11078: WHERE pl.po_line_id = pod.po_line_id
11079: AND pcr.change_request_group_id(+) = p_pochggrp_id
11080: AND pcr.action_type(+) = 'MODIFICATION'
11110:
11111: into l_old_amount_release, l_new_amount_release
11112:
11113: FROM po_change_requests pcr,
11114: po_lines_all pol,
11115: po_line_locations_all pll
11116: WHERE pcr.change_request_group_id= p_pochggrp_id
11117: AND pcr.po_release_id = p_poheader_id
11118: AND pcr.document_line_id = pol.po_line_id
11562: ( nvl(pll.amount,0)-nvl(pll.amount_cancelled,0) ),
11563: ( nvl(pll.quantity,0)- nvl(pll.quantity_cancelled,0)) * pol.unit_price
11564: )
11565: from po_change_requests,
11566: po_lines_all pol,
11567: po_line_locations_all pll
11568: where change_request_group_id = p_chg_request_grp_id
11569: and document_line_id = p_po_line_id
11570: and document_line_location_id = pll.line_location_id
11578: l_progress := '001';
11579:
11580: select matching_basis,org_id,item_id,unit_price
11581: into l_po_matching_basis,l_po_org_id,l_item_id,l_unit_price
11582: from po_lines_all
11583: where po_line_id = p_po_line_id;
11584:
11585: l_progress := '002';
11586:
11590: ( nvl(pll.quantity,0)- nvl(pll.quantity_cancelled,0)) * pol.unit_price
11591: )
11592: )
11593: into l_old_amount
11594: FROM po_lines_all pol,
11595: po_line_locations_all pll
11596: WHERE pol.po_line_id = p_po_line_id
11597: AND pol.po_line_id = pll.po_line_id;
11598:
11622: exception
11623: when no_data_found then
11624: select pol.unit_price
11625: into l_new_price
11626: from po_lines_all pol
11627: where pol.po_line_id = p_po_line_id;
11628:
11629: l_pcr_new_price := null;
11630: end;
11720:
11721: select ( (l_new_price * l_new_quantity) -
11722: nvl(pll.price_override,pol.unit_price) * pll.quantity )
11723: into l_shipmt_amt_increase
11724: from po_lines_all pol,
11725: po_line_locations_all pll
11726: where pll.line_location_id = l_pcr_line_loc_id
11727: and pol.po_line_id = pll.po_line_id ;
11728:
11746: select decode(pol.matching_basis, 'AMOUNT',pol.amount,
11747: (nvl(pcr.new_price,pol.unit_price) * pol.quantity ))
11748: into l_new_amount
11749: from po_change_requests pcr,
11750: po_lines_all pol
11751: where pcr.change_request_group_id = p_chg_request_grp_id
11752: and pol.po_line_id = p_po_line_id
11753: and pcr.document_line_id = p_po_line_id
11754: and pcr.request_level = 'LINE'