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

Line 2855: po_line_locations_all pll,

2851: SELECT pcr.new_amount,(nvl(pll.quantity,0)-nvl(pll.quantity_cancelled,0)),pol.matching_basis
2852: into l_tmp_new_amount, l_old_quantity,l_matching_basis
2853: FROM po_change_requests pcr,
2854: po_lines_all pol,
2855: po_line_locations_all pll,
2856: po_headers_all poh
2857: WHERE pcr.change_request_group_id= p_group_id
2858: AND pcr.request_status IN ('PENDING', 'BUYER_APP', 'ACCEPTED', 'REJECTED')
2859: AND pol.po_line_id = p_line_id

Line 2941: po_line_locations_all pll,

2937: into
2938: l_blanket_header_id
2939: from
2940: po_requisition_lines_all prl,
2941: po_line_locations_all pll,
2942: po_lines_all pol
2943: where
2944: pol.po_line_id = p_line_id and
2945: pol.po_line_id = pll.po_line_id and

Line 3109: l_uom po_line_locations_all.unit_meas_lookup_code%TYPE;

3105: l_old_price number;
3106: l_new_price number;
3107: l_action_type po_change_requests.action_type%TYPE;
3108: l_item_desc po_lines_all.item_description%TYPE;
3109: l_uom po_line_locations_all.unit_meas_lookup_code%TYPE;
3110: l_line_quantity number;
3111: l_line_uom po_lines_all.unit_meas_lookup_code%TYPE;
3112: l_ship_to_location hr_locations_all.location_code%type;
3113: l_request_reason po_change_requests.request_reason%type;

Line 3189: po_line_locations_all pll,

3185: nvl(pcr.old_price, nvl(pll.price_override, pol.unit_price)),
3186: (nvl(pll.quantity,0)-nvl(pll.quantity_cancelled,0)))))
3187: from po_change_requests pcr,
3188: po_lines_all pol,
3189: po_line_locations_all pll,
3190: hr_locations_all hla
3191: where pcr.change_request_group_id=grp_id
3192: and pcr.request_status = 'PENDING'
3193: and pcr.document_header_id=pol.po_header_id

Line 3208: po_line_locations_all pll

3204: cursor l_get_line_qty(grp_id number, line_id number) is
3205: select sum(decode(pcr.action_type, 'CANCELLATION', 0,
3206: nvl(pcr.new_quantity, pll.quantity)))
3207: from po_change_requests pcr,
3208: po_line_locations_all pll
3209: where pcr.change_request_group_id(+)=grp_id
3210: and pcr.document_line_id(+)=line_id
3211: and pcr.document_line_location_id(+)=pll.line_location_id
3212: and pcr.request_level(+)='SHIPMENT'

Line 3238: po_line_locations_all pll,

3234: nvl(pll.accrue_on_receipt_flag,'N'),
3235: nvl(pll.quantity_billed,0)
3236: from po_lines_all pol,
3237: po_headers_all poh,
3238: po_line_locations_all pll,
3239: po_change_requests pcr
3240: where pol.po_line_id=line_id
3241: and pol.po_header_id=poh.po_header_id
3242: and pll.po_line_id=line_id

Line 3268: l_old_start_date po_line_locations_all.start_date%TYPE;

3264: NL VARCHAR2(1) := fnd_global.newline;
3265:
3266: l_has_temp_labor boolean :=false;
3267: l_num_temp_labors number :=0;
3268: l_old_start_date po_line_locations_all.start_date%TYPE;
3269: l_new_start_date po_line_locations_all.start_date%TYPE;
3270: l_old_end_date po_line_locations_all.end_date%TYPE;
3271: l_new_end_date po_line_locations_all.end_date%TYPE;
3272: l_old_amount po_line_locations_all.amount%TYPE;

Line 3269: l_new_start_date po_line_locations_all.start_date%TYPE;

3265:
3266: l_has_temp_labor boolean :=false;
3267: l_num_temp_labors number :=0;
3268: l_old_start_date po_line_locations_all.start_date%TYPE;
3269: l_new_start_date po_line_locations_all.start_date%TYPE;
3270: l_old_end_date po_line_locations_all.end_date%TYPE;
3271: l_new_end_date po_line_locations_all.end_date%TYPE;
3272: l_old_amount po_line_locations_all.amount%TYPE;
3273: l_new_amount po_line_locations_all.amount%TYPE;

Line 3270: l_old_end_date po_line_locations_all.end_date%TYPE;

3266: l_has_temp_labor boolean :=false;
3267: l_num_temp_labors number :=0;
3268: l_old_start_date po_line_locations_all.start_date%TYPE;
3269: l_new_start_date po_line_locations_all.start_date%TYPE;
3270: l_old_end_date po_line_locations_all.end_date%TYPE;
3271: l_new_end_date po_line_locations_all.end_date%TYPE;
3272: l_old_amount po_line_locations_all.amount%TYPE;
3273: l_new_amount po_line_locations_all.amount%TYPE;
3274:

Line 3271: l_new_end_date po_line_locations_all.end_date%TYPE;

3267: l_num_temp_labors number :=0;
3268: l_old_start_date po_line_locations_all.start_date%TYPE;
3269: l_new_start_date po_line_locations_all.start_date%TYPE;
3270: l_old_end_date po_line_locations_all.end_date%TYPE;
3271: l_new_end_date po_line_locations_all.end_date%TYPE;
3272: l_old_amount po_line_locations_all.amount%TYPE;
3273: l_new_amount po_line_locations_all.amount%TYPE;
3274:
3275: -- added for retroactive pricing checks

Line 3272: l_old_amount po_line_locations_all.amount%TYPE;

3268: l_old_start_date po_line_locations_all.start_date%TYPE;
3269: l_new_start_date po_line_locations_all.start_date%TYPE;
3270: l_old_end_date po_line_locations_all.end_date%TYPE;
3271: l_new_end_date po_line_locations_all.end_date%TYPE;
3272: l_old_amount po_line_locations_all.amount%TYPE;
3273: l_new_amount po_line_locations_all.amount%TYPE;
3274:
3275: -- added for retroactive pricing checks
3276: l_retropricing varchar2(20) := '';

Line 3273: l_new_amount po_line_locations_all.amount%TYPE;

3269: l_new_start_date po_line_locations_all.start_date%TYPE;
3270: l_old_end_date po_line_locations_all.end_date%TYPE;
3271: l_new_end_date po_line_locations_all.end_date%TYPE;
3272: l_old_amount po_line_locations_all.amount%TYPE;
3273: l_new_amount po_line_locations_all.amount%TYPE;
3274:
3275: -- added for retroactive pricing checks
3276: l_retropricing varchar2(20) := '';
3277: l_quantity_received number;

Line 3278: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%type;

3274:
3275: -- added for retroactive pricing checks
3276: l_retropricing varchar2(20) := '';
3277: l_quantity_received number;
3278: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%type;
3279: l_quantity_billed number;
3280: l_call_price_break boolean := true;
3281:
3282:

Line 3683: po_line_locations_all pll,

3679: into
3680: l_blanket_header_id, l_blanket_line_num
3681: from
3682: po_requisition_lines_all prl,
3683: po_line_locations_all pll,
3684: po_lines_all pol
3685: where
3686: pol.po_line_id = l_line_id and
3687: pol.po_line_id = pll.po_line_id and

Line 3917: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%type;

3913:
3914:
3915: l_retropricing varchar2(20) := '';
3916: l_quantity_received number;
3917: l_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%type;
3918: l_quantity_billed number;
3919: l_call_price_break boolean := true;
3920: l_new_amount number;
3921: l_document_type varchar2(100);

Line 3936: po_line_locations_all pll

3932: cursor l_get_line_qty(grp_id number, line_id number) is
3933: select sum(decode(pcr.action_type, 'CANCELLATION', 0,
3934: nvl(pcr.new_quantity, pll.quantity)))
3935: from po_change_requests pcr,
3936: po_line_locations_all pll
3937: where pcr.change_request_group_id = grp_id
3938: and pcr.document_line_id = line_id
3939: and pcr.document_line_location_id = pll.line_location_id
3940: and pcr.request_level = 'SHIPMENT'

Line 3969: po_line_locations_all pll,

3965: pol.from_line_id,
3966: pol.contract_id
3967: from po_lines_all pol,
3968: po_headers_all poh,
3969: po_line_locations_all pll,
3970: po_change_requests pcr
3971: where pol.po_line_id=line_id
3972: and pol.po_header_id=poh.po_header_id
3973: and pll.po_line_id=line_id

Line 4184: po_line_locations_all pll,

4180: l_quantity_received,
4181: l_accrue_on_receipt_flag,
4182: l_quantity_billed
4183: FROM po_lines_all pol,
4184: po_line_locations_all pll,
4185: po_change_requests pcr
4186: WHERE pcr.change_request_group_id = p_group_id
4187: and pll.line_location_id = p_line_location_id
4188: and pcr.document_line_location_id = pll.line_location_id

Line 4312: po_line_locations_all pll,

4308: --using distinct as a line on a blanket can exist on multiple requisitions
4309: select distinct prl.blanket_po_header_id
4310: into l_blanket_po_header_id
4311: from po_requisition_lines_all prl,
4312: po_line_locations_all pll,
4313: po_lines_all pol
4314: where pol.po_line_id = p_line_id
4315: and pol.po_line_id = pll.po_line_id
4316: and prl.line_location_id = pll.line_location_id

Line 4343: po_line_locations_all pll,

4339: select pcr.old_price, nvl(pcr.old_price,nvl(pll.price_override, pol.unit_price))
4340: into l_pcr_old_price, l_price
4341: FROM po_change_requests pcr,
4342: po_lines_all pol,
4343: po_line_locations_all pll,
4344: po_headers_all poh
4345: WHERE pcr.change_request_group_id= p_group_id
4346: AND pcr.request_status IN ('PENDING', 'BUYER_APP', 'ACCEPTED', 'REJECTED')
4347: AND pol.po_line_id = p_line_id

Line 4360: po_line_locations_all pll,

4356: select pcr.old_price, pol.unit_price,nvl(pcr.old_price,nvl(pll.price_override, pol.unit_price))
4357: into l_pcr_old_price,l_pol_unit_price,l_price
4358: FROM po_change_requests pcr,
4359: po_lines_all pol,
4360: po_line_locations_all pll,
4361: po_headers_all poh
4362: WHERE pcr.change_request_group_id= p_group_id
4363: AND pcr.request_status IN ('PENDING', 'BUYER_APP', 'ACCEPTED', 'REJECTED')
4364: AND pol.po_line_id = p_line_id