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 2680: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;

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

Line 2681: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;

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

Line 2682: l_master_org_id mtl_parameters.master_organization_id % TYPE;

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

Line 2707: from mtl_parameters

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

Line 2837: mtl_parameters mp

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

Line 2852: mtl_parameters mp

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

Line 9459: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;

9455: , p_inventory_org_id IN NUMBER
9456: , p_inv_org_master_org_flag IN VARCHAR2
9457: , x_return_status OUT NOCOPY VARCHAR2
9458: ) IS
9459: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;
9460: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;
9461: l_master_org_id mtl_parameters.master_organization_id % TYPE;
9462: l_api_name_full VARCHAR2(61);
9463: l_col VARCHAR2(61);

Line 9460: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;

9456: , p_inv_org_master_org_flag IN VARCHAR2
9457: , x_return_status OUT NOCOPY VARCHAR2
9458: ) IS
9459: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;
9460: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;
9461: l_master_org_id mtl_parameters.master_organization_id % TYPE;
9462: l_api_name_full VARCHAR2(61);
9463: l_col VARCHAR2(61);
9464: BEGIN

Line 9461: l_master_org_id mtl_parameters.master_organization_id % TYPE;

9457: , x_return_status OUT NOCOPY VARCHAR2
9458: ) IS
9459: l_eam_enabled mtl_parameters.eam_enabled_flag % TYPE;
9460: l_maint_org_id mtl_parameters.maint_organization_id % TYPE;
9461: l_master_org_id mtl_parameters.master_organization_id % TYPE;
9462: l_api_name_full VARCHAR2(61);
9463: l_col VARCHAR2(61);
9464: BEGIN
9465: l_api_name_full := G_PKG_NAME || '.validate_maint_organization_id';

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

Line 9592: l_maint_org_id mtl_parameters.organization_id % 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;
9595: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9596: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;

Line 9593: l_master_org_id mtl_parameters.organization_id % 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;
9595: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9596: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9597: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;

Line 9594: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % 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;
9595: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9596: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9597: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9598: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;