APPS.PO_AUTOCREATE_DOC dependencies on HR_LOCATIONS_ALL

Line 2844: c1_deliver_to_location_code hr_locations_all.location_code%type;

2840: c1_rel_gen_method varchar2(25);
2841: c1_item_id number;
2842: c1_pcard_id number;
2843: c1_contract_id number;
2844: c1_deliver_to_location_code hr_locations_all.location_code%type;
2845: c1_dest_org_id number; -- Consigned FPI
2846: c1_dest_type_code po_requisition_lines.destination_type_code%TYPE; -- Consigned FPI
2847: c1_cons_from_supp_flag varchar2(1); -- Consigned FPI
2848: c1_labor_req_line_id number; --

Line 2892: c2_deliver_to_location_code hr_locations_all.location_code%type;

2888: x_first_time_for_this_comb varchar2(5);
2889: x_interface_header_id number;
2890: x_suggested_vendor_contact_id number;
2891: x_suggested_vendor_contact varchar2(240);
2892: c2_deliver_to_location_code hr_locations_all.location_code%type;
2893: x_prev_sug_vendor_contact_id number;
2894: x_carry_contact_to_po_flag varchar2(10);
2895:
2896: /* x_grouping_allowed varchar2(1); Bug 2974129 */

Line 2960: hr_locations_all hrl

2956: prl.purchase_basis
2957: --
2958: from po_wf_candidate_req_lines_temp prlt,
2959: po_requisition_lines prl,
2960: hr_locations_all hrl
2961: where prlt.process_code = 'PENDING'
2962: and prlt.group_id = x_group_id
2963: and prlt.requisition_line_id = prl.requisition_line_id
2964: and prl.deliver_to_location_id = hrl.location_id(+) -- bug 2709046

Line 3005: hr_locations_all hrl

3001: --
3002:
3003: from po_wf_candidate_req_lines_temp prlt,
3004: po_requisition_lines prl,
3005: hr_locations_all hrl
3006: where prlt.process_code = 'PENDING'
3007: and prlt.group_id = x_group_id
3008: and prlt.requisition_line_id = prl.requisition_line_id
3009: and prl.deliver_to_location_id = hrl.location_id(+) -- bug 2709046