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 2480: FROM csi_item_instances a,

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

Line 2508: FROM csi_item_instances a,

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

Line 2595: FROM csi_item_instances a,

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

Line 2617: FROM csi_item_instances a,

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

Line 3236: FROM csi_item_instances a,

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

Line 3254: FROM csi_item_instances a,

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

Line 3280: FROM csi_item_instances a,

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

Line 3297: FROM csi_item_instances a,

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

Line 4259: FROM csi_item_instances

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

Line 4323: FROM CSI_ITEM_INSTANCES

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

Line 4398: FROM CSI_ITEM_INSTANCES

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

Line 4429: FROM csi_item_instances

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

Line 4491: FROM CSI_ITEM_INSTANCES

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

Line 4520: FROM csi_item_instances

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

Line 6347: FROM csi_item_instances a

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

Line 6387: FROM csi_item_instances a

6383:
6384: x_return_status := FND_API.G_RET_STS_SUCCESS;
6385:
6386: SELECT 'x' INTO l_dummy
6387: FROM csi_item_instances a
6388: WHERE a.instance_id = p_customer_product_id
6389: AND a.install_location_type_code = 'HZ_PARTY_SITES'
6390: AND a.install_location_id = p_install_site_id;
6391:

Line 6726: FROM CSI_ITEM_INSTANCES

6722: x_return_status := FND_API.G_RET_STS_SUCCESS;
6723:
6724: SELECT 'X'
6725: INTO l_dummy
6726: FROM CSI_ITEM_INSTANCES
6727: WHERE INSTANCE_ID = p_cp_component_id
6728: AND INVENTORY_ITEM_ID = p_inv_component_id;
6729:
6730: EXCEPTION

Line 6768: FROM CSI_ITEM_INSTANCES

6764:
6765: x_return_status := FND_API.G_RET_STS_SUCCESS;
6766:
6767: SELECT 'X' INTO l_dummy
6768: FROM CSI_ITEM_INSTANCES
6769: WHERE INSTANCE_ID = p_cp_subcomponent_id
6770: AND INVENTORY_ITEM_ID = p_inv_subcomponent_id;
6771:
6772: EXCEPTION

Line 6859: from csi_item_instances

6855: x_return_status := FND_API.G_RET_STS_SUCCESS;
6856: /*
6857: select 1
6858: into l_dummy
6859: from csi_item_instances
6860: where
6861:
6862: */
6863:

Line 9484: -- csi_item_instances table.

9480: -- -----------------------------------------------------------------------------
9481: -- Procedure Name : validate_customer_product_id
9482: -- Parameter :
9483: -- IN : p_customer_product_id This foreign key to
9484: -- csi_item_instances table.
9485: -- : p_customer_id Service Request customer
9486: -- : p_inventory_org_id Inventory organization id
9487: -- : p_maint_organization_id maintenance organization
9488: -- : p_inv_org_master_org_flag

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

9491: -- customer product
9492: -- : x_return_stauts indicates if validation failed or
9493: -- succeeded
9494: -- Description : This procedure performs following checks
9495: -- 1. customer product should exist in csi_item_instances table
9496: -- 2. service request customer should be related to customer
9497: -- product
9498: -- 3. Inventory item associated with customer product should
9499: -- 3.1 enabled

Line 9535: l_source_table csi_item_instances.owner_party_source_table % TYPE;

9531: AND party_id = p_customer_id
9532: AND party_source_table = 'HZ_PARTIES';
9533:
9534: l_party_id csi_i_parties.party_id % TYPE;
9535: l_source_table csi_item_instances.owner_party_source_table % TYPE;
9536: l_loc_type csi_item_instances.location_type_code % TYPE;
9537: l_external_ref csi_item_instances.external_reference % TYPE;
9538: l_serial_number csi_item_instances.serial_number % TYPE;
9539: l_inv_org_id mtl_parameters.organization_id % TYPE;

Line 9536: l_loc_type csi_item_instances.location_type_code % TYPE;

9532: AND party_source_table = 'HZ_PARTIES';
9533:
9534: l_party_id csi_i_parties.party_id % TYPE;
9535: l_source_table csi_item_instances.owner_party_source_table % TYPE;
9536: l_loc_type csi_item_instances.location_type_code % TYPE;
9537: l_external_ref csi_item_instances.external_reference % TYPE;
9538: l_serial_number csi_item_instances.serial_number % TYPE;
9539: l_inv_org_id mtl_parameters.organization_id % TYPE;
9540: l_maint_org_id mtl_parameters.organization_id % TYPE;

Line 9537: l_external_ref csi_item_instances.external_reference % TYPE;

9533:
9534: l_party_id csi_i_parties.party_id % TYPE;
9535: l_source_table csi_item_instances.owner_party_source_table % TYPE;
9536: l_loc_type csi_item_instances.location_type_code % TYPE;
9537: l_external_ref csi_item_instances.external_reference % TYPE;
9538: l_serial_number csi_item_instances.serial_number % TYPE;
9539: l_inv_org_id mtl_parameters.organization_id % TYPE;
9540: l_maint_org_id mtl_parameters.organization_id % TYPE;
9541: l_master_org_id mtl_parameters.organization_id % TYPE;

Line 9538: l_serial_number csi_item_instances.serial_number % TYPE;

9534: l_party_id csi_i_parties.party_id % TYPE;
9535: l_source_table csi_item_instances.owner_party_source_table % TYPE;
9536: l_loc_type csi_item_instances.location_type_code % TYPE;
9537: l_external_ref csi_item_instances.external_reference % TYPE;
9538: l_serial_number csi_item_instances.serial_number % TYPE;
9539: l_inv_org_id mtl_parameters.organization_id % TYPE;
9540: l_maint_org_id mtl_parameters.organization_id % TYPE;
9541: l_master_org_id mtl_parameters.organization_id % TYPE;
9542: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % TYPE;