[Home] [Help]
335: AND MI.organization_id = c_inventory_org_id
336: AND MI.enabled_flag = 'Y'
337: AND SYSDATE BETWEEN NVL( MI.start_date_active, SYSDATE )
338: AND NVL( MI.end_date_active, SYSDATE )
339: AND DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y';
340: *//*
341: SELECT DISTINCT
342: mtl.INVENTORY_ITEM_ID ,
343: mtl.organization_id ,
346: MTL_SYSTEM_ITEMS_KFV MTL
347: , fnd_lookup_values_vl IT
348: , MTL_PARAMETERS MP
349: where
350: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
351: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
352: and MTL.inventory_item_flag = 'Y'
353: AND IT.lookup_code (+) = MTL.item_type
354: AND IT.lookup_type (+) = 'ITEM_TYPE'
377: SELECT DISTINCT MI.inventory_item_id,
378: MI.organization_id,
379: NVL(MI.inventory_item_flag,'X')
380: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
381: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
382: AND MP.organization_id = MI.organization_id
383: AND MI.inventory_item_id = c_inventory_item_id
384: AND MI.organization_id = c_inventory_org_id
385: AND MI.enabled_flag = 'Y'
393: from MTL_SYSTEM_ITEMS_KFV MTL
394: , MTL_PARAMETERS MP
395: , fnd_lookup_values_vl IT
396: where
397: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
398: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
399: and MTL.inventory_item_flag = 'Y'
400: AND IT.lookup_code (+) = MTL.item_type
401: AND IT.lookup_type (+) = 'ITEM_TYPE'
537: NVL(MI.mtl_transactions_enabled_flag,'X'),
538: NVL(MI.stock_enabled_flag,'X'),
539: NVL(MI.wip_supply_type,0)
540: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
541: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
542: AND MP.master_organization_id = MI.organization_id
543: AND MI.concatenated_segments = c_item_number
544: --AND MI.organization_id = c_inventory_org_id
545: AND MP.master_organization_id = c_inventory_org_id
556: NVL(mtl.stock_enabled_flag,'X'),
557: NVL(mtl.wip_supply_type,0)
558: from ahl_mtl_items_non_ou_v mtl
559: where
560: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mtl.eam_enabled_flag )='Y'
561: AND mtl.enabled_flag = 'Y'
562: AND SYSDATE BETWEEN NVL( mtl.start_date_active, SYSDATE )
563: AND NVL( mtl.end_date_active, SYSDATE )
564: and upper(mtl.concatenated_segments) like upper(c_item_number)
588: NVL(MI.mtl_transactions_enabled_flag,'X'),
589: NVL(MI.stock_enabled_flag,'X'),
590: NVL(MI.wip_supply_type,0)
591: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
592: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
593: AND MP.master_organization_id = MI.organization_id
594: AND MI.inventory_item_id = c_inventory_item_id
595: --AND MI.organization_id = c_inventory_org_id
596: AND MP.master_organization_id = c_inventory_org_id
607: NVL(mtl.stock_enabled_flag,'X'),
608: NVL(mtl.wip_supply_type,0)
609: from ahl_mtl_items_non_ou_v mtl
610: where
611: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mtl.eam_enabled_flag )='Y'
612: AND mtl.enabled_flag = 'Y'
613: AND SYSDATE BETWEEN NVL( mtl.start_date_active, SYSDATE )
614: AND NVL( mtl.end_date_active, SYSDATE )
615: and mtl.inventory_item_id = c_inventory_item_id
746: MI.outside_operation_flag,
747: MI.purchasing_item_flag,
748: MI.purchasing_enabled_flag
749: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI,mtl_system_items_b mast
750: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
751: AND MP.organization_id = MI.organization_id
752: AND MP.master_organization_id = mast.organization_id
753: AND MI.concatenated_segments = c_item_number
754: AND MI.enabled_flag = 'Y'
764: MI.outside_operation_flag,
765: MI.purchasing_item_flag,
766: MI.purchasing_enabled_flag
767: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
768: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
769: AND MP.organization_id = MI.organization_id
770: AND MI.inventory_item_id = c_inventory_item_id
771: AND MI.organization_id = c_inventory_org_id
772: AND MI.enabled_flag = 'Y'
911: AND MI.enabled_flag = 'Y'
912: AND upper(MP.ORGANIZATION_CODE)=upper(c_org_code)
913: AND SYSDATE BETWEEN NVL( MI.start_date_active, SYSDATE )
914: AND NVL( MI.end_date_active, SYSDATE )
915: AND DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y';
916: */
917: /*
918: SELECT DISTINCT
919: mtl.INVENTORY_ITEM_ID ,
923: , MTL_PARAMETERS MP
924: , MTL_PARAMETERS MP1
925: , fnd_lookup_values_vl IT
926: where
927: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
928: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
929: and MP.MASTER_ORGANIZATION_ID = MP1.ORGANIZATION_ID
930: and sysdate between nvl( MTL.start_date_active, sysdate )
931: and nvl( MTL.end_date_active, sysdate )
961: AND MI.organization_id = c_inventory_org_id
962: AND MI.enabled_flag = 'Y'
963: AND SYSDATE BETWEEN NVL( MI.start_date_active, SYSDATE )
964: AND NVL( MI.end_date_active, SYSDATE )
965: AND DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y';
966: */
967: /*SELECT DISTINCT
968: mtl.INVENTORY_ITEM_ID ,
969: mtl.organization_id ,
971: from MTL_SYSTEM_ITEMS_KFV MTL
972: , MTL_PARAMETERS MP
973: , fnd_lookup_values_vl IT
974: where
975: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
976: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
977: and sysdate between nvl( MTL.start_date_active, sysdate )
978: and nvl( MTL.end_date_active, sysdate )
979: and IT.lookup_code (+) = MTL.item_type
3882: FND_MSG_PUB.add;
3883: RETURN;
3884: END IF;
3885:
3886: AHL_UTIL_PKG.get_appln_usage
3887: (
3888: x_appln_code => l_appln_code,
3889: x_return_status => x_return_status
3890: );