APPS.CSP_PART_SEARCH_PVT dependencies on CSP_REQUIREMENT_HEADERS

Line 341: csp_requirement_headers crh,

337: hl.geometry
338: from csp_planning_parameters cpp,
339: csp_dedicated_sites cds,
340: jtf_tasks_b jtb,
341: csp_requirement_headers crh,
342: hz_party_sites hps,
343: hz_locations hl
344: where cds.planning_parameters_id = cpp.planning_parameters_id
345: and nvl(cpp.stocking_site_excl,'N') = 'N'

Line 954: csp_requirement_headers crh

950: crh.need_by_date,
951: crh.timezone_id,
952: crh.ship_to_location_id
953: from csp_requirement_lines crl,
954: csp_requirement_headers crh
955: where crh.requirement_header_id = p_search_params.requirement_header_id
956: and crl.requirement_header_id = crh.requirement_header_id;
957:
958: l_resource_rec csp_sch_int_pvt.csp_sch_resources_rec_typ;

Line 2123: csp_requirement_headers crh

2119: AND hps.party_site_id =
2120: ( SELECT DISTINCT party_site_id
2121: FROM po_location_associations_all ploc,
2122: hz_cust_acct_sites_all hcsa,
2123: csp_requirement_headers crh
2124: WHERE crh.requirement_header_id = p_req_header_id
2125: AND ploc.location_id = crh.ship_to_location_id
2126: --AND ploc.customer_id = hcsa.cust_account_id
2127: AND ploc.address_id = hcsa.cust_acct_site_id