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

Line 140: -- csi_item_instances table.

136: -- -----------------------------------------------------------------------------
137: -- Procedure Name : get_customer_product_details
138: -- Parameter :
139: -- IN : p_customer_product_id This foreign key to
140: -- csi_item_instances table.
141: -- OUT :
142: -- : x_party_source_table Party source table.
143: -- : x_party_id customer product customer Id
144: -- : x_inv_master_org_id inventory master org

Line 193: csi_item_instances

189: , location_type_code
190: , external_reference
191: , serial_number
192: FROM
193: csi_item_instances
194: WHERE instance_id = p_customer_product_id;
195: --
196: BEGIN
197: OPEN c_cp;

Line 798: l_cp_ref_number csi_item_instances.instance_number % type;

794: )
795: IS
796: l_api_name CONSTANT VARCHAR2(30) := 'Convert_CP_Ref_Number_To_ID';
797: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
798: l_cp_ref_number csi_item_instances.instance_number % type;
799:
800: BEGIN
801: -- Initialize the return status.
802: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 808: FROM csi_item_instances

804:
805: -- Fetch ID from database.
806: SELECT instance_id
807: INTO p_customer_product_id
808: FROM csi_item_instances
809: WHERE instance_number = l_cp_ref_number;
810:
811: EXCEPTION
812: WHEN NO_DATA_FOUND THEN

Line 2482: FROM csi_item_instances a,

2478:
2479: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
2480: SELECT a.inventory_item_id
2481: INTO p_inventory_item_id
2482: FROM csi_item_instances a,
2483: mtl_system_items_b b,
2484: csi_i_parties cip
2485: WHERE a.instance_id = p_customer_product_id
2486: --AND a.owner_party_id = p_customer_id

Line 2510: FROM csi_item_instances a,

2506: AND rownum<2;
2507: ELSE
2508: SELECT a.inventory_item_id
2509: INTO p_inventory_item_id
2510: FROM csi_item_instances a,
2511: mtl_system_items_b b,
2512: csi_i_parties cip
2513: WHERE a.instance_id = p_customer_product_id
2514: -- AND a.owner_party_id = p_customer_id

Line 2597: FROM csi_item_instances a,

2593:
2594: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
2595:
2596: SELECT 'x' INTO l_dummy
2597: FROM csi_item_instances a,
2598: mtl_system_items_b b,
2599: csi_i_parties cip
2600: WHERE a.instance_id = p_customer_product_id
2601: AND a.serial_number = p_current_serial_number

Line 2619: FROM csi_item_instances a,

2615: AND b.organization_id = p_inventory_org_id
2616: AND rownum<2;
2617: ELSE
2618: SELECT 'x' INTO l_dummy
2619: FROM csi_item_instances a,
2620: mtl_system_items_b b,
2621: csi_i_parties cip
2622: WHERE a.instance_id = p_customer_product_id
2623: AND a.serial_number = p_current_serial_number

Line 3238: FROM csi_item_instances a,

3234:
3235: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
3236:
3237: SELECT 'x' INTO l_dummy
3238: FROM csi_item_instances a,
3239: mtl_system_items_b b,
3240: csi_i_parties cip
3241: WHERE a.instance_id = p_customer_product_id
3242: AND a.external_reference = p_external_reference

Line 3256: FROM csi_item_instances a,

3252: AND rownum<2;
3253: ELSE
3254:
3255: SELECT 'x' INTO l_dummy
3256: FROM csi_item_instances a,
3257: mtl_system_items_b b,
3258: csi_i_parties cip
3259: WHERE a.instance_id = p_customer_product_id
3260: AND a.external_reference = p_external_reference

Line 3282: FROM csi_item_instances a,

3278:
3279: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
3280:
3281: SELECT 'X' INTO l_dummy
3282: FROM csi_item_instances a,
3283: mtl_system_items_b b,
3284: csi_i_parties cip
3285: WHERE b.inventory_item_id = p_inventory_item_id
3286: AND b.organization_id = p_inventory_org_id

Line 3299: FROM csi_item_instances a,

3295:
3296: ELSE
3297:
3298: SELECT 'X' INTO l_dummy
3299: FROM csi_item_instances a,
3300: mtl_system_items_b b,
3301: csi_i_parties cip
3302: WHERE b.inventory_item_id = p_inventory_item_id
3303: AND b.organization_id = p_inventory_org_id

Line 4261: FROM csi_item_instances

4257: IF l_rev_control_code = 2 THEN
4258: BEGIN
4259: SELECT 'x'
4260: INTO l_test
4261: FROM csi_item_instances
4262: WHERE instance_id = p_customer_product_id
4263: AND inventory_revision = p_product_revision;
4264:
4265: EXCEPTION

Line 4325: FROM CSI_ITEM_INSTANCES

4321: l_product_version cs_incidents_all_b.component_version % type;
4322:
4323: CURSOR c_inv_item
4324: IS SELECT inventory_item_id, inventory_revision
4325: FROM CSI_ITEM_INSTANCES
4326: WHERE INSTANCE_ID = p_instance_id;
4327:
4328:
4329: CURSOR c_rev_code(l_inv_item_id IN NUMBER)

Line 4400: FROM CSI_ITEM_INSTANCES

4396: l_rev_control_code NUMBER;
4397:
4398: CURSOR c_inv_item
4399: IS SELECT inventory_item_id
4400: FROM CSI_ITEM_INSTANCES
4401: WHERE INSTANCE_ID = p_cp_component_id;
4402:
4403:
4404: CURSOR c_rev_code(l_inv_item_id IN NUMBER)

Line 4431: FROM csi_item_instances

4427: IF l_rev_control_code = 2 THEN
4428: BEGIN
4429: SELECT 'x'
4430: INTO l_test
4431: FROM csi_item_instances
4432: WHERE instance_id = p_cp_component_id
4433: AND inventory_revision = p_component_version;
4434:
4435: EXCEPTION

Line 4493: FROM CSI_ITEM_INSTANCES

4489: l_rev_control_code NUMBER;
4490:
4491: CURSOR c_inv_item
4492: IS SELECT inventory_item_id
4493: FROM CSI_ITEM_INSTANCES
4494: WHERE INSTANCE_ID = p_cp_subcomponent_id;
4495:
4496:
4497: CURSOR c_rev_code(l_inv_item_id IN NUMBER)

Line 4522: FROM csi_item_instances

4518: IF l_rev_control_code = 2 THEN
4519: BEGIN
4520: SELECT 'x'
4521: INTO l_test
4522: FROM csi_item_instances
4523: WHERE instance_id = p_cp_subcomponent_id
4524: AND inventory_revision = p_subcomponent_version;
4525:
4526: EXCEPTION

Line 6349: FROM csi_item_instances a

6345:
6346: x_return_status := FND_API.G_RET_STS_SUCCESS;
6347:
6348: SELECT 'x' INTO l_dummy
6349: FROM csi_item_instances a
6350: WHERE a.instance_id = p_customer_product_id
6351: AND a.location_id = p_incident_location_id;
6352:
6353: EXCEPTION

Line 6383: l_install_site_id csi_item_instances.install_location_id%type;

6379: IS
6380: l_dummy VARCHAR2(1);
6381: l_api_name CONSTANT VARCHAR2(30) := 'CP_INSTALL_SITE_CROSS_VAL';
6382: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
6383: l_install_site_id csi_item_instances.install_location_id%type;
6384: l_install_site_type csi_item_instances.install_location_type_code%type;
6385:
6386: BEGIN
6387:

Line 6384: l_install_site_type csi_item_instances.install_location_type_code%type;

6380: l_dummy VARCHAR2(1);
6381: l_api_name CONSTANT VARCHAR2(30) := 'CP_INSTALL_SITE_CROSS_VAL';
6382: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
6383: l_install_site_id csi_item_instances.install_location_id%type;
6384: l_install_site_type csi_item_instances.install_location_type_code%type;
6385:
6386: BEGIN
6387:
6388: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6394: FROM csi_item_instances a

6390: --do the install site validation only when instance has a valid install site type
6391: -- of type 'HZ_PARTY_SITES'
6392: SELECT a.install_location_id,a.install_location_type_code
6393: INTO l_install_site_id,l_install_site_type
6394: FROM csi_item_instances a
6395: WHERE a.instance_id = p_customer_product_id;
6396: -- If instance has install party sites of type HZ_PARTY_SITES
6397: -- then validate that
6398: IF l_install_site_type='HZ_PARTY_SITES' THEN

Line 6742: FROM CSI_ITEM_INSTANCES

6738: x_return_status := FND_API.G_RET_STS_SUCCESS;
6739:
6740: SELECT 'X'
6741: INTO l_dummy
6742: FROM CSI_ITEM_INSTANCES
6743: WHERE INSTANCE_ID = p_cp_component_id
6744: AND INVENTORY_ITEM_ID = p_inv_component_id;
6745:
6746: EXCEPTION

Line 6784: FROM CSI_ITEM_INSTANCES

6780:
6781: x_return_status := FND_API.G_RET_STS_SUCCESS;
6782:
6783: SELECT 'X' INTO l_dummy
6784: FROM CSI_ITEM_INSTANCES
6785: WHERE INSTANCE_ID = p_cp_subcomponent_id
6786: AND INVENTORY_ITEM_ID = p_inv_subcomponent_id;
6787:
6788: EXCEPTION

Line 6875: from csi_item_instances

6871: x_return_status := FND_API.G_RET_STS_SUCCESS;
6872: /*
6873: select 1
6874: into l_dummy
6875: from csi_item_instances
6876: where
6877:
6878: */
6879:

Line 9536: -- csi_item_instances table.

9532: -- -----------------------------------------------------------------------------
9533: -- Procedure Name : validate_customer_product_id
9534: -- Parameter :
9535: -- IN : p_customer_product_id This foreign key to
9536: -- csi_item_instances table.
9537: -- : p_customer_id Service Request customer
9538: -- : p_inventory_org_id Inventory organization id
9539: -- : p_maint_organization_id maintenance organization
9540: -- : p_inv_org_master_org_flag

Line 9547: -- 1. customer product should exist in csi_item_instances table

9543: -- customer product
9544: -- : x_return_stauts indicates if validation failed or
9545: -- succeeded
9546: -- Description : This procedure performs following checks
9547: -- 1. customer product should exist in csi_item_instances table
9548: -- 2. service request customer should be related to customer
9549: -- product
9550: -- 3. Inventory item associated with customer product should
9551: -- 3.1 enabled

Line 9587: l_source_table csi_item_instances.owner_party_source_table % TYPE;

9583: AND party_id = p_customer_id
9584: AND party_source_table = 'HZ_PARTIES';
9585:
9586: l_party_id csi_i_parties.party_id % TYPE;
9587: l_source_table csi_item_instances.owner_party_source_table % TYPE;
9588: l_loc_type csi_item_instances.location_type_code % TYPE;
9589: l_external_ref csi_item_instances.external_reference % TYPE;
9590: l_serial_number csi_item_instances.serial_number % TYPE;
9591: l_inv_org_id mtl_parameters.organization_id % TYPE;

Line 9588: l_loc_type csi_item_instances.location_type_code % TYPE;

9584: AND party_source_table = 'HZ_PARTIES';
9585:
9586: l_party_id csi_i_parties.party_id % TYPE;
9587: l_source_table csi_item_instances.owner_party_source_table % TYPE;
9588: l_loc_type csi_item_instances.location_type_code % TYPE;
9589: l_external_ref csi_item_instances.external_reference % TYPE;
9590: l_serial_number csi_item_instances.serial_number % TYPE;
9591: l_inv_org_id mtl_parameters.organization_id % TYPE;
9592: l_maint_org_id mtl_parameters.organization_id % TYPE;

Line 9589: l_external_ref csi_item_instances.external_reference % TYPE;

9585:
9586: l_party_id csi_i_parties.party_id % TYPE;
9587: l_source_table csi_item_instances.owner_party_source_table % TYPE;
9588: l_loc_type csi_item_instances.location_type_code % TYPE;
9589: l_external_ref csi_item_instances.external_reference % TYPE;
9590: l_serial_number csi_item_instances.serial_number % TYPE;
9591: l_inv_org_id mtl_parameters.organization_id % TYPE;
9592: l_maint_org_id mtl_parameters.organization_id % TYPE;
9593: l_master_org_id mtl_parameters.organization_id % TYPE;

Line 9590: l_serial_number csi_item_instances.serial_number % TYPE;

9586: l_party_id csi_i_parties.party_id % TYPE;
9587: l_source_table csi_item_instances.owner_party_source_table % TYPE;
9588: l_loc_type csi_item_instances.location_type_code % TYPE;
9589: l_external_ref csi_item_instances.external_reference % TYPE;
9590: l_serial_number csi_item_instances.serial_number % TYPE;
9591: l_inv_org_id mtl_parameters.organization_id % TYPE;
9592: l_maint_org_id mtl_parameters.organization_id % TYPE;
9593: l_master_org_id mtl_parameters.organization_id % TYPE;
9594: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % TYPE;