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 MTL_PARAMETERS

Line 39: FROM mtl_parameters

35: SELECT
36: NVL(maint_organization_id,-1)
37: , NVL(master_organization_id,-1)
38: , NVL(eam_enabled_flag,'X')
39: FROM mtl_parameters
40: WHERE organization_id = p_org_id;
41: BEGIN
42: OPEN c_org_info;
43: FETCH c_org_info INTO x_maint_org_id, x_master_org_id, x_eam_enabled_flag;

Line 2678: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;

2674: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Inventory_Org';
2675: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
2676: l_dummy VARCHAR2(1);
2677:
2678: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;
2679: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;
2680: l_master_org_id mtl_parameters.master_organization_id % TYPE;
2681: BEGIN
2682: -- Initialize Return Status to SUCCESS

Line 2679: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;

2675: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
2676: l_dummy VARCHAR2(1);
2677:
2678: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;
2679: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;
2680: l_master_org_id mtl_parameters.master_organization_id % TYPE;
2681: BEGIN
2682: -- Initialize Return Status to SUCCESS
2683: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2680: l_master_org_id mtl_parameters.master_organization_id % TYPE;

2676: l_dummy VARCHAR2(1);
2677:
2678: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;
2679: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;
2680: l_master_org_id mtl_parameters.master_organization_id % TYPE;
2681: BEGIN
2682: -- Initialize Return Status to SUCCESS
2683: x_return_status := FND_API.G_RET_STS_SUCCESS;
2684: x_inv_org_master_org_flag := NULL;

Line 2705: from mtl_parameters

2701: x_inv_org_master_org_flag := 'N';
2702: END IF;
2703: /***** replace this query ith the above procedure call 7/27/05 smisra
2704: select 'x' INTO l_dummy
2705: from mtl_parameters
2706: where organization_id = p_inv_org_id;
2707: ***/
2708: EXCEPTION
2709: WHEN NO_DATA_FOUND THEN

Line 2835: mtl_parameters mp

2831: THEN
2832: SELECT 'X'
2833: INTO l_dummy
2834: FROM mtl_system_items_b msi,
2835: mtl_parameters mp
2836: WHERE msi.inventory_item_id = p_inventory_item_id
2837: AND msi.enabled_flag = 'Y'
2838: AND msi.serv_req_enabled_code = 'E'
2839: AND msi.organization_id = mp.organization_id

Line 2850: mtl_parameters mp

2846: ELSE
2847: SELECT 'X'
2848: INTO l_dummy
2849: FROM mtl_system_items_b msi,
2850: mtl_parameters mp
2851: WHERE msi.inventory_item_id = p_inventory_item_id
2852: AND msi.enabled_flag = 'Y'
2853: AND msi.serv_req_enabled_code = 'E'
2854: AND msi.organization_id = mp.organization_id

Line 9407: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;

9403: , p_inventory_org_id IN NUMBER
9404: , p_inv_org_master_org_flag IN VARCHAR2
9405: , x_return_status OUT NOCOPY VARCHAR2
9406: ) IS
9407: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;
9408: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;
9409: l_master_org_id mtl_parameters.master_organization_id % TYPE;
9410: l_api_name_full VARCHAR2(61);
9411: l_col VARCHAR2(61);

Line 9408: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;

9404: , p_inv_org_master_org_flag IN VARCHAR2
9405: , x_return_status OUT NOCOPY VARCHAR2
9406: ) IS
9407: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;
9408: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;
9409: l_master_org_id mtl_parameters.master_organization_id % TYPE;
9410: l_api_name_full VARCHAR2(61);
9411: l_col VARCHAR2(61);
9412: BEGIN

Line 9409: l_master_org_id mtl_parameters.master_organization_id % TYPE;

9405: , x_return_status OUT NOCOPY VARCHAR2
9406: ) IS
9407: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;
9408: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;
9409: l_master_org_id mtl_parameters.master_organization_id % TYPE;
9410: l_api_name_full VARCHAR2(61);
9411: l_col VARCHAR2(61);
9412: BEGIN
9413: l_api_name_full := G_PKG_NAME || '.validate_maint_organization_id';

Line 9539: l_inv_org_id mtl_parameters.organization_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;
9543: l_eam_type mtl_system_items_b.eam_item_type % TYPE;

Line 9540: l_maint_org_id mtl_parameters.organization_id % 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;
9543: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9544: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;

Line 9541: l_master_org_id mtl_parameters.organization_id % 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;
9543: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9544: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9545: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;

Line 9542: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % 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;
9543: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9544: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9545: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9546: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;