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 HR_LOCATIONS

Line 219: location hr_locations.location_code%TYPE,

215: quantity po_requisition_lines.quantity%TYPE,
216: unit_price po_requisition_lines.unit_price%TYPE,
217: line_amount NUMBER,
218: need_by_date po_requisition_lines.need_by_date%TYPE,
219: location hr_locations.location_code%TYPE,
220: requestor per_people_f.full_name%TYPE,
221: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
222: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
223: txn_curr_code po_requisition_lines.currency_code%TYPE,

Line 679: hr_locations_all hrt,

675: rql.line_location_id,
676: rql.cancel_flag
677: FROM po_requisition_lines rql,
678: mtl_system_items_kfv msi,
679: hr_locations_all hrt,
680: per_all_people_f per,
681: mtl_units_of_measure muom,
682: org_organization_definitions org,
683: PO_LOOKUP_CODES PLC

Line 1190: hr_locations_all hrt,

1186: rql.line_location_id,
1187: rql.cancel_flag
1188: FROM po_requisition_lines rql,
1189: mtl_system_items_kfv msi,
1190: hr_locations_all hrt,
1191: per_all_people_f per,
1192: mtl_units_of_measure muom,
1193: org_organization_definitions org,
1194: PO_LOOKUP_CODES PLC

Line 3087: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;

3083: l_order_date date;
3084: l_fob po_headers_all.fob_lookup_code%TYPE;
3085: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3086: l_ship_to_id number;
3087: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3088: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3089: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3090: l_ship_city hr_locations_all.town_or_city%TYPE;
3091: l_ship_state hr_locations_all.region_1%TYPE;

Line 3088: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

3084: l_fob po_headers_all.fob_lookup_code%TYPE;
3085: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3086: l_ship_to_id number;
3087: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3088: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3089: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3090: l_ship_city hr_locations_all.town_or_city%TYPE;
3091: l_ship_state hr_locations_all.region_1%TYPE;
3092: l_ship_zip hr_locations_all.postal_code%TYPE;

Line 3089: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

3085: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3086: l_ship_to_id number;
3087: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3088: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3089: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3090: l_ship_city hr_locations_all.town_or_city%TYPE;
3091: l_ship_state hr_locations_all.region_1%TYPE;
3092: l_ship_zip hr_locations_all.postal_code%TYPE;
3093:

Line 3090: l_ship_city hr_locations_all.town_or_city%TYPE;

3086: l_ship_to_id number;
3087: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3088: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3089: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3090: l_ship_city hr_locations_all.town_or_city%TYPE;
3091: l_ship_state hr_locations_all.region_1%TYPE;
3092: l_ship_zip hr_locations_all.postal_code%TYPE;
3093:
3094: l_num_of_changes number;

Line 3091: l_ship_state hr_locations_all.region_1%TYPE;

3087: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3088: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3089: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3090: l_ship_city hr_locations_all.town_or_city%TYPE;
3091: l_ship_state hr_locations_all.region_1%TYPE;
3092: l_ship_zip hr_locations_all.postal_code%TYPE;
3093:
3094: l_num_of_changes number;
3095: l_num_of_cancels number;

Line 3092: l_ship_zip hr_locations_all.postal_code%TYPE;

3088: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3089: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;
3090: l_ship_city hr_locations_all.town_or_city%TYPE;
3091: l_ship_state hr_locations_all.region_1%TYPE;
3092: l_ship_zip hr_locations_all.postal_code%TYPE;
3093:
3094: l_num_of_changes number;
3095: l_num_of_cancels number;
3096: l_document1 VARCHAR2(32000) := '';

Line 3112: l_ship_to_location hr_locations_all.location_code%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;
3114:
3115: l_old_quantity number;
3116: l_new_quantity number;

Line 3190: hr_locations_all hla

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

Line 3372: from hr_locations_all

3368: where vendor_site_id = l_vendor_site_id;
3369:
3370: select address_line_1, address_line_2, address_line_3, town_or_city, region_1, postal_code
3371: into l_ship_addr_l1, l_ship_addr_l2, l_ship_addr_l3, l_ship_city, l_ship_state, l_ship_zip
3372: from hr_locations_all
3373: where location_id = l_ship_to_id;
3374:
3375: if (display_type = 'text/html') then
3376: