[Home] [Help]
334: cursor c_sites is
335: select cpp.organization_id,
336: cpp.secondary_inventory,
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,
475: csi.condition_type,
476: csi.owner_resource_type,
477: csi.owner_resource_id
478: from csp_sec_inventories csi,
479: csp_planning_parameters cpp,
480: hz_locations hl
481: where cpp.organization_id = csi.organization_id
482: and cpp.secondary_inventory = csi.secondary_inventory_name
483: and cpp.stocking_site_type = 'TECHNICIAN'
641: cpp.timezone_id,
642: sysdate)),2,'OPEN','CLOSED')
643: from
644: csp_required_parts_temp crpt,
645: csp_planning_parameters cpp,
646: csp_open_closed_v cocv,
647: hz_locations hl
648: where cpp.stocking_site_type = 'UNMANNED'
649: and nvl(cpp.stocking_site_excl,'N') = 'N'
738: cpp.timezone_id,
739: sysdate)),2,'OPEN','CLOSED')
740: from
741: csp_required_parts_temp crpt,
742: csp_planning_parameters cpp,
743: csp_open_closed_v cocv,
744: hz_locations hl
745: where cpp.stocking_site_type = 'MANNED'
746: and cpp.organization_id = cr.organization_id
833: cpp.timezone_id,
834: sysdate)),2,'OPEN','CLOSED')
835: from
836: csp_required_parts_temp crpt,
837: csp_planning_parameters cpp,
838: csp_open_closed_v cocv,
839: hz_locations hl
840: where cpp.organization_id = p_search_params.source_organization_id
841: and nvl(cpp.stocking_site_excl,'N') = 'N'
1064:
1065: cursor c_my_location is
1066: select hl.geometry
1067: from hz_locations hl,
1068: csp_planning_parameters cpp
1069: where cpp.organization_id = l_organization_id
1070: and cpp.secondary_inventory = l_subinventory_code
1071: and hl.location_id = cpp.hz_location_id;
1072:
1879: jtf_cal_shifts_b jcsb,
1880: jtf_cal_shift_assign jcsa,
1881: jtf_calendars_b jcb,
1882: fnd_lookup_values_vl flvv,
1883: csp_planning_parameters cpp
1884: WHERE jcsa.calendar_id = jcb.calendar_id
1885: AND jcsb.shift_id = jcsa.shift_id
1886: AND jcsc.shift_id = jcsa.shift_id
1887: and flvv.lookup_type = 'NUMBERS'
2104: INTO l_src_geo
2105: FROM HZ_LOCATIONS
2106: WHERE location_id =
2107: ( SELECT DISTINCT hz_location_id
2108: FROM csp_planning_parameters
2109: WHERE organization_id = p_src_org_id
2110: AND NVL(SECONDARY_INVENTORY, 'NULL') = NVL(p_src_subinv, 'NULL')
2111: );
2112: