APPS.PO_AUTOCREATE_DOC dependencies on HR_LOCATIONS_ALL

Line 3087: c1_deliver_to_location_code hr_locations_all.location_code%type;

3083: c1_rel_gen_method varchar2(25);
3084: c1_item_id number;
3085: c1_pcard_id number;
3086: c1_contract_id number;
3087: c1_deliver_to_location_code hr_locations_all.location_code%type;
3088: c1_dest_org_id number; -- Consigned FPI
3089: c1_dest_type_code po_requisition_lines.destination_type_code%TYPE; -- Consigned FPI
3090: c1_cons_from_supp_flag varchar2(1); -- Consigned FPI
3091: c1_labor_req_line_id number; --

Line 3135: c2_deliver_to_location_code hr_locations_all.location_code%type;

3131: x_first_time_for_this_comb varchar2(5);
3132: x_interface_header_id number;
3133: x_suggested_vendor_contact_id number;
3134: x_suggested_vendor_contact varchar2(240);
3135: c2_deliver_to_location_code hr_locations_all.location_code%type;
3136: x_prev_sug_vendor_contact_id number;
3137: x_carry_contact_to_po_flag varchar2(10);
3138:
3139: /* x_grouping_allowed varchar2(1); Bug 2974129 */

Line 3205: hr_locations_all hrl

3201: prl.purchase_basis
3202: --
3203: from po_wf_candidate_req_lines_temp prlt,
3204: po_requisition_lines prl,
3205: hr_locations_all hrl
3206: where prlt.process_code = 'PENDING'
3207: and prlt.group_id = x_group_id
3208: and prlt.requisition_line_id = prl.requisition_line_id
3209: and prl.deliver_to_location_id = hrl.location_id(+) -- bug 2709046

Line 3251: hr_locations_all hrl

3247: --
3248:
3249: from po_wf_candidate_req_lines_temp prlt,
3250: po_requisition_lines prl,
3251: hr_locations_all hrl
3252: where prlt.process_code = 'PENDING'
3253: and prlt.group_id = x_group_id
3254: and prlt.requisition_line_id = prl.requisition_line_id
3255: and prl.deliver_to_location_id = hrl.location_id(+) -- bug 2709046