[Home] [Help]
890: union
891: select mena.maintenance_object_id,cii.inventory_item_id,cii2.serial_number
892: from csi_item_instances cii,
893: mtl_eam_network_assets mena,
894: mtl_parameters mp,
895: csi_item_instances cii2
896: where cii.instance_number = p_asset_number
897: and mena.network_object_id = cii.instance_id
898: and cii2.instance_id = mena.maintenance_object_id
1213: select count(*)
1214: into l_asset_count
1215: from mtl_eam_network_assets mena,
1216: csi_item_instances cii,
1217: mtl_parameters mp
1218: where cii.instance_number = p_asset_number
1219: and mena.network_object_id = cii.instance_id
1220: and cii.inventory_item_id = p_asset_group_id
1221: and mp.maint_organization_id = p_org_id
2098: select count(*)
2099: into l_asset_count
2100: from mtl_eam_network_assets mena,
2101: csi_item_instances cii,
2102: mtl_parameters mp
2103: where cii.instance_number = l_asset_number
2104: and mena.network_object_id = cii.instance_id
2105: and cii.inventory_item_id = l_inventory_item_id
2106: and mp.maint_organization_id = p_org_id
2145: union /* Added the union clause for Bug 5315176 */
2146: select mena.maintenance_object_id
2147: from mtl_eam_network_assets mena,
2148: csi_item_instances cii,
2149: mtl_parameters mp
2150: where cii.instance_number = l_asset_number
2151: and mena.network_object_id = cii.instance_id
2152: and cii.inventory_item_id = l_inventory_item_id
2153: and mp.maint_organization_id = p_org_id
2181: union /* Added the union clause for Bug 5315176 */
2182: select mena.maintenance_object_id
2183: from mtl_eam_network_assets mena,
2184: csi_item_instances cii,
2185: mtl_parameters mp
2186: where cii.instance_number = l_asset_number
2187: and mena.network_object_id = cii.instance_id
2188: and cii.inventory_item_id = l_inventory_item_id
2189: and mp.maint_organization_id = p_org_id
2219: union /* Added the union clause for Bug 5315176 */
2220: select mena.maintenance_object_id
2221: from mtl_eam_network_assets mena,
2222: csi_item_instances cii,
2223: mtl_parameters mp
2224: where cii.instance_number = l_asset_number
2225: and mena.network_object_id = cii.instance_id
2226: and cii.inventory_item_id = l_inventory_item_id
2227: and mp.maint_organization_id = p_org_id
2255: union /* Added the union clause for Bug 5315176 */
2256: select mena.maintenance_object_id
2257: from mtl_eam_network_assets mena,
2258: csi_item_instances cii,
2259: mtl_parameters mp
2260: where cii.instance_number = l_asset_number
2261: and mena.network_object_id = cii.instance_id
2262: and cii.inventory_item_id = l_inventory_item_id
2263: and mp.maint_organization_id = p_org_id
2998:
2999: /* Bug #1950738. Use default cost group of organization */
3000: SELECT NVL(default_cost_group_id,-1)
3001: INTO l_cost_group_id
3002: FROM mtl_parameters
3003: WHERE organization_id = l_organization_id;
3004:
3005: IF (l_wip_project_id <> -1) THEN
3006:
3126: NVL(mp.avg_rates_cost_type_id,-1)),
3127: mp.primary_cost_method
3128: INTO l_rates_ct,
3129: l_primary_cost_method
3130: FROM mtl_parameters mp
3131: WHERE mp.organization_id = l_organization_id;
3132:
3133: IF (l_rates_ct = -1) THEN
3134:
5705: -- Get EAM enabled flag for organization
5706: l_stmt_num := 40;
5707: SELECT nvl(eam_enabled_flag,'N')
5708: INTO l_eam_flag
5709: FROM mtl_parameters
5710: WHERE organization_id = l_org_id;
5711:
5712: if (l_debug = 'Y') then
5713: fnd_file.put_line(fnd_file.log,'EAM flag: ' || l_eam_flag);
6294:
6295: l_stmt_num := 90;
6296: select organization_code
6297: into l_directItem_rec.organization_code
6298: from mtl_parameters
6299: where organization_id = l_directItem_rec.organization_id;
6300: if (l_debug = 'Y') then
6301: fnd_file.put_line(fnd_file.log,'organization code ' || l_directItem_rec.organization_code);
6302: end if;