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_REQCHANGEREQUESTWF_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 1144: po_line_locations_all pll,

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
1148: and pcr.request_status='PENDING'

Line 1876: UPDATE po_line_locations_all

1872:
1873: -- when change request is rejected,
1874: -- set po shipments approved_flag column value to 'Y'
1875: -- since when change request is submitted, it is set to 'R'
1876: UPDATE po_line_locations_all
1877: SET
1878: approved_flag = 'Y',
1879: last_update_date = sysdate,
1880: last_updated_by = fnd_global.user_id,

Line 1958: from po_line_locations_all

1954:
1955: if (l_document_type <> 'RELEASE') then
1956: select count(1)
1957: into l_num_of_shipments
1958: from po_line_locations_all
1959: where po_line_id = l_document_line_id
1960: and nvl(cancel_flag, 'N') = 'N';
1961:
1962: if (l_num_of_shipments = 1) then

Line 2348: SELECT PO_LINE_ID INTO l_po_line_id FROM po_line_locations_all WHERE LINE_LOCATION_ID =

2344: end if;
2345: x_progress:='ACCEPTANCE:006-'||to_char(l_change_request_id);
2346:
2347: -- Bug# 15875594 Changes Starts
2348: SELECT PO_LINE_ID INTO l_po_line_id FROM po_line_locations_all WHERE LINE_LOCATION_ID =
2349: (SELECT LINE_LOCATION_ID FROM po_requisition_lines_all WHERE requisition_line_id= l_document_line_id);
2350:
2351: -- copy change request attachments to req line.
2352: fnd_attached_documents2_pkg.copy_attachments('REQ_LINE_CHANGES',l_document_line_id,NULL,NULL,NULL,NULL,'REQ_LINES',

Line 3017: l_po_uom po_line_locations_all.UNIT_MEAS_LOOKUP_CODE%TYPE;

3013: l_new_ship_quantity number;
3014: l_old_ship_quantity number;
3015: l_item_id number;
3016: l_req_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%TYPE;
3017: l_po_uom po_line_locations_all.UNIT_MEAS_LOOKUP_CODE%TYPE;
3018: l_old_amount number;
3019: l_new_amount number;
3020: l_old_start_date date;
3021: l_new_start_date date;

Line 3090: po_line_locations_all pll,

3086: to_number(null) dist_amount,
3087: max(prl.matching_basis),
3088: max(pcr.requester_id) requester_id -- Bug # 3862383
3089: from po_change_requests pcr,
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

Line 3146: po_line_locations_all pll,

3142: to_number(null) dist_amount,
3143: prl.matching_basis,
3144: pcr.requester_id requester_id -- Bug # 3862383
3145: from po_change_requests pcr,
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

Line 3209: po_line_locations_all pll,

3205: pod.amount_ordered dist_amount,
3206: prl.matching_basis,
3207: pcr.requester_id requester_id -- Bug # 3862383
3208: from po_change_requests pcr,
3209: po_line_locations_all pll,
3210: po_requisition_lines_all prl,
3211: po_headers_all poh,
3212: po_releases_all por,
3213: po_distributions_all pod,

Line 4068: UPDATE po_line_locations_all

4064: where po_header_id = p_document_id;
4065:
4066: x_progress := '002';
4067:
4068: UPDATE po_line_locations_all
4069: SET
4070: approved_flag='R',
4071: last_update_date = sysdate,
4072: last_updated_by = fnd_global.user_id,

Line 4127: UPDATE po_line_locations_all

4123: where po_release_id = p_document_id;
4124:
4125: x_progress := '002';
4126:
4127: UPDATE po_line_locations_all
4128: SET
4129: approved_flag = 'R',
4130: last_update_date = sysdate,
4131: last_updated_by = fnd_global.user_id,

Line 9746: po_line_locations_all pll

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
9750: AND pcr.document_line_id=pol.po_line_id

Line 11115: po_line_locations_all pll

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
11119: AND pcr.request_status NOT IN ('ACCEPTED', 'REJECTED')

Line 11567: po_line_locations_all pll

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
11571: and pol.po_line_id = document_line_id

Line 11595: po_line_locations_all pll

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:
11599: l_progress := '003';

Line 11658: po_line_locations_all pll

11654: begin
11655: select (pcr.new_amount - pll.amount)
11656: into l_shipmt_amt_increase
11657: from po_change_requests pcr,
11658: po_line_locations_all pll
11659: where pcr.change_request_group_id = p_chg_request_grp_id
11660: and pcr.document_line_location_id = l_pcr_line_loc_id
11661: and pll.line_location_id = l_pcr_line_loc_id
11662: and pcr.request_level = 'SHIPMENT'

Line 11682: po_line_locations_all pll

11678: begin
11679: SELECT pcr.new_quantity,pcr.new_quantity,pll.unit_meas_lookup_code,pll.price_override
11680: into l_pcr_new_quantity,l_new_quantity,l_unit_lookup_code,l_price_override
11681: FROM po_change_requests pcr,
11682: po_line_locations_all pll
11683: WHERE pcr.change_request_group_id = p_chg_request_grp_id
11684: AND pcr.document_line_location_id = l_pcr_line_loc_id
11685: AND pll.line_location_id = l_pcr_line_loc_id
11686: AND pcr.action_type(+) = 'MODIFICATION'

Line 11693: -- if no qty change, we get the qty from po_line_locations_all.

11689: AND pcr.request_level = 'SHIPMENT'
11690: AND pcr.new_quantity is not null;
11691:
11692: exception
11693: -- if no qty change, we get the qty from po_line_locations_all.
11694: when no_data_found then
11695: select (pll.quantity - pll.quantity_cancelled)
11696: into l_new_quantity
11697: from po_line_locations_all pll

Line 11697: from po_line_locations_all pll

11693: -- if no qty change, we get the qty from po_line_locations_all.
11694: when no_data_found then
11695: select (pll.quantity - pll.quantity_cancelled)
11696: into l_new_quantity
11697: from po_line_locations_all pll
11698: where pll.line_location_id = l_pcr_line_loc_id;
11699:
11700: l_pcr_new_quantity := null;
11701:

Line 11725: po_line_locations_all pll

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:
11729: end if;