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.OKL_SERVICE_INTEGRATION_PVT dependencies on CSI_ITEM_INSTANCES

Line 2300: FROM csi_item_instances

2296:
2297: CURSOR csi_csr (p_instance_id NUMBER) IS
2298: SELECT install_location_id location_id,
2299: install_location_type_code location_type_code
2300: FROM csi_item_instances
2301: WHERE instance_id = p_instance_id;
2302:
2303: CURSOR hz_loc_csr (p_instance_id NUMBER) IS -- for location type = 'HZ_LOCATIONS'
2304: SELECT csi.install_location_id

Line 2305: FROM csi_item_instances csi,

2301: WHERE instance_id = p_instance_id;
2302:
2303: CURSOR hz_loc_csr (p_instance_id NUMBER) IS -- for location type = 'HZ_LOCATIONS'
2304: SELECT csi.install_location_id
2305: FROM csi_item_instances csi,
2306: hz_locations hl
2307: WHERE install_location_type_code = 'HZ_LOCATIONS'
2308: AND csi.owner_party_source_table = 'HZ_PARTIES'
2309: AND hl.location_id = csi.install_location_id

Line 2323: FROM csi_item_instances csi,

2319: AND csi.instance_id = p_instance_id;
2320:
2321: CURSOR hz_party_site_csr (p_instance_id NUMBER) IS -- for location type = 'HZ_PARTY_SITES'
2322: SELECT hps.location_id
2323: FROM csi_item_instances csi,
2324: hz_party_sites hps
2325: WHERE install_location_type_code = 'HZ_PARTY_SITES'
2326: AND csi.owner_party_source_table = 'HZ_PARTIES'
2327: AND csi.install_location_id = hps.party_site_id

Line 2348: l_location_id CSI_ITEM_INSTANCES.LOCATION_ID%TYPE;

2344:
2345: l_api_name VARCHAR2(35) := 'check_prod_instance';
2346: l_proc_name VARCHAR2(35) := 'CHECK_PROD_INSTANCE';
2347:
2348: l_location_id CSI_ITEM_INSTANCES.LOCATION_ID%TYPE;
2349: l_location_type_code CSI_ITEM_INSTANCES.LOCATION_TYPE_CODE%TYPE;
2350: l_hz_Loc_id HZ_LOCATIONS.location_id%TYPE;
2351:
2352: instance_failed EXCEPTION;

Line 2349: l_location_type_code CSI_ITEM_INSTANCES.LOCATION_TYPE_CODE%TYPE;

2345: l_api_name VARCHAR2(35) := 'check_prod_instance';
2346: l_proc_name VARCHAR2(35) := 'CHECK_PROD_INSTANCE';
2347:
2348: l_location_id CSI_ITEM_INSTANCES.LOCATION_ID%TYPE;
2349: l_location_type_code CSI_ITEM_INSTANCES.LOCATION_TYPE_CODE%TYPE;
2350: l_hz_Loc_id HZ_LOCATIONS.location_id%TYPE;
2351:
2352: instance_failed EXCEPTION;
2353:

Line 3105: csi_item_instances csi,

3101: csi.install_location_type_code location_type_code,
3102: csi.instance_number
3103: FROM okc_k_rel_objs krel,
3104: okc_k_items kitem,
3105: csi_item_instances csi,
3106: okc_k_lines_b line,
3107: okc_line_styles_b style,
3108: OKC_STATUSES_B sts
3109: WHERE krel.rty_code = 'OKLSRV'