[Home] [Help]
1112: union
1113: select mena.maintenance_object_id,cii.inventory_item_id,cii2.serial_number
1114: from csi_item_instances cii,
1115: mtl_eam_network_assets mena,
1116: mtl_parameters mp,
1117: csi_item_instances cii2
1118: where cii.instance_number = p_asset_number
1119: and mena.network_object_id = cii.instance_id
1120: and cii2.instance_id = mena.maintenance_object_id
1435: select count(*)
1436: into l_asset_count
1437: from mtl_eam_network_assets mena,
1438: csi_item_instances cii,
1439: mtl_parameters mp
1440: where cii.instance_number = p_asset_number
1441: and mena.network_object_id = cii.instance_id
1442: and cii.inventory_item_id = p_asset_group_id
1443: and mp.maint_organization_id = p_org_id
2320: select count(*)
2321: into l_asset_count
2322: from mtl_eam_network_assets mena,
2323: csi_item_instances cii,
2324: mtl_parameters mp
2325: where cii.instance_number = l_asset_number
2326: and mena.network_object_id = cii.instance_id
2327: and cii.inventory_item_id = l_inventory_item_id
2328: and mp.maint_organization_id = p_org_id
2367: union /* Added the union clause for Bug 5315176 */
2368: select mena.maintenance_object_id
2369: from mtl_eam_network_assets mena,
2370: csi_item_instances cii,
2371: mtl_parameters mp
2372: where cii.instance_number = l_asset_number
2373: and mena.network_object_id = cii.instance_id
2374: and cii.inventory_item_id = l_inventory_item_id
2375: and mp.maint_organization_id = p_org_id
2403: union /* Added the union clause for Bug 5315176 */
2404: select mena.maintenance_object_id
2405: from mtl_eam_network_assets mena,
2406: csi_item_instances cii,
2407: mtl_parameters mp
2408: where cii.instance_number = l_asset_number
2409: and mena.network_object_id = cii.instance_id
2410: and cii.inventory_item_id = l_inventory_item_id
2411: and mp.maint_organization_id = p_org_id
2441: union /* Added the union clause for Bug 5315176 */
2442: select mena.maintenance_object_id
2443: from mtl_eam_network_assets mena,
2444: csi_item_instances cii,
2445: mtl_parameters mp
2446: where cii.instance_number = l_asset_number
2447: and mena.network_object_id = cii.instance_id
2448: and cii.inventory_item_id = l_inventory_item_id
2449: and mp.maint_organization_id = p_org_id
2477: union /* Added the union clause for Bug 5315176 */
2478: select mena.maintenance_object_id
2479: from mtl_eam_network_assets mena,
2480: csi_item_instances cii,
2481: mtl_parameters mp
2482: where cii.instance_number = l_asset_number
2483: and mena.network_object_id = cii.instance_id
2484: and cii.inventory_item_id = l_inventory_item_id
2485: and mp.maint_organization_id = p_org_id
3220:
3221: /* Bug #1950738. Use default cost group of organization */
3222: SELECT NVL(default_cost_group_id,-1)
3223: INTO l_cost_group_id
3224: FROM mtl_parameters
3225: WHERE organization_id = l_organization_id;
3226:
3227: IF (l_wip_project_id <> -1) THEN
3228:
3348: NVL(mp.avg_rates_cost_type_id,-1)),
3349: mp.primary_cost_method
3350: INTO l_rates_ct,
3351: l_primary_cost_method
3352: FROM mtl_parameters mp
3353: WHERE mp.organization_id = l_organization_id;
3354:
3355: IF (l_rates_ct = -1) THEN
3356:
6001: -- Get EAM enabled flag for organization
6002: l_stmt_num := 40;
6003: SELECT nvl(eam_enabled_flag,'N')
6004: INTO l_eam_flag
6005: FROM mtl_parameters
6006: WHERE organization_id = l_org_id;
6007:
6008: if (l_debug = 'Y') then
6009: fnd_file.put_line(fnd_file.log,'EAM flag: ' || l_eam_flag);
6648:
6649: l_stmt_num := 90;
6650: select organization_code
6651: into l_directItem_rec.organization_code
6652: from mtl_parameters
6653: where organization_id = l_directItem_rec.organization_id;
6654: if (l_debug = 'Y') then
6655: fnd_file.put_line(fnd_file.log,'organization code ' || l_directItem_rec.organization_code);
6656: end if;
6827: wcti.encumbrance_quantity,
6828: wcti.encumbrance_ccid,
6829: mp.encumbrance_reversal_flag
6830: from wip_cost_txn_interface wcti
6831: , mtl_parameters mp
6832: where wcti.group_id = p_group_id
6833: and wcti.process_status = 2
6834: and wcti.organization_id = mp.organization_id;
6835:
11480: FROM wip_entities we
11481: , wip_discrete_jobs wdj
11482: , wip_accounting_classes wac
11483: , mtl_system_items msi
11484: , mtl_parameters mp
11485: WHERE we.wip_entity_id = p_wip_entity_id
11486: AND we.wip_entity_id = wdj.wip_entity_id
11487: AND wac.organization_id = wdj.organization_id
11488: AND wac.class_code = wdj.class_code
11624: x_msg_data OUT NOCOPY VARCHAR2)
11625: IS
11626: CURSOR c(p_organization_id IN NUMBER) IS
11627: SELECT decode(encumbrance_reversal_flag,1,1,2)
11628: FROM mtl_parameters
11629: WHERE organization_id = p_organization_id;
11630: l_encumbrance_reversal_flag NUMBER;
11631: l_no_org VARCHAR2(1) := 'N';
11632: l_no_org_exc EXCEPTION;