[Home] [Help]
333: AND MI.organization_id = c_inventory_org_id
334: AND MI.enabled_flag = 'Y'
335: AND SYSDATE BETWEEN NVL( MI.start_date_active, SYSDATE )
336: AND NVL( MI.end_date_active, SYSDATE )
337: AND DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y';
338: *//*
339: SELECT DISTINCT
340: mtl.INVENTORY_ITEM_ID ,
341: mtl.organization_id ,
344: MTL_SYSTEM_ITEMS_KFV MTL
345: , fnd_lookup_values_vl IT
346: , MTL_PARAMETERS MP
347: where
348: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
349: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
350: and MTL.inventory_item_flag = 'Y'
351: AND IT.lookup_code (+) = MTL.item_type
352: AND IT.lookup_type (+) = 'ITEM_TYPE'
375: SELECT DISTINCT MI.inventory_item_id,
376: MI.organization_id,
377: NVL(MI.inventory_item_flag,'X')
378: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
379: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
380: AND MP.organization_id = MI.organization_id
381: AND MI.inventory_item_id = c_inventory_item_id
382: AND MI.organization_id = c_inventory_org_id
383: AND MI.enabled_flag = 'Y'
391: from MTL_SYSTEM_ITEMS_KFV MTL
392: , MTL_PARAMETERS MP
393: , fnd_lookup_values_vl IT
394: where
395: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
396: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
397: and MTL.inventory_item_flag = 'Y'
398: AND IT.lookup_code (+) = MTL.item_type
399: AND IT.lookup_type (+) = 'ITEM_TYPE'
535: NVL(MI.mtl_transactions_enabled_flag,'X'),
536: NVL(MI.stock_enabled_flag,'X'),
537: NVL(MI.wip_supply_type,0)
538: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
539: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
540: AND MP.master_organization_id = MI.organization_id
541: AND MI.concatenated_segments = c_item_number
542: --AND MI.organization_id = c_inventory_org_id
543: AND MP.master_organization_id = c_inventory_org_id
554: NVL(mtl.stock_enabled_flag,'X'),
555: NVL(mtl.wip_supply_type,0)
556: from ahl_mtl_items_non_ou_v mtl
557: where
558: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mtl.eam_enabled_flag )='Y'
559: AND mtl.enabled_flag = 'Y'
560: AND SYSDATE BETWEEN NVL( mtl.start_date_active, SYSDATE )
561: AND NVL( mtl.end_date_active, SYSDATE )
562: and upper(mtl.concatenated_segments) like upper(c_item_number)
586: NVL(MI.mtl_transactions_enabled_flag,'X'),
587: NVL(MI.stock_enabled_flag,'X'),
588: NVL(MI.wip_supply_type,0)
589: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
590: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
591: AND MP.master_organization_id = MI.organization_id
592: AND MI.inventory_item_id = c_inventory_item_id
593: --AND MI.organization_id = c_inventory_org_id
594: AND MP.master_organization_id = c_inventory_org_id
605: NVL(mtl.stock_enabled_flag,'X'),
606: NVL(mtl.wip_supply_type,0)
607: from ahl_mtl_items_non_ou_v mtl
608: where
609: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mtl.eam_enabled_flag )='Y'
610: AND mtl.enabled_flag = 'Y'
611: AND SYSDATE BETWEEN NVL( mtl.start_date_active, SYSDATE )
612: AND NVL( mtl.end_date_active, SYSDATE )
613: and mtl.inventory_item_id = c_inventory_item_id
742: MI.outside_operation_flag,
743: MI.purchasing_item_flag,
744: MI.purchasing_enabled_flag
745: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
746: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
747: AND MP.organization_id = MI.organization_id
748: AND MI.concatenated_segments = c_item_number
749: AND MI.enabled_flag = 'Y'
750: AND SYSDATE BETWEEN NVL( MI.start_date_active, SYSDATE )
758: MI.outside_operation_flag,
759: MI.purchasing_item_flag,
760: MI.purchasing_enabled_flag
761: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
762: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
763: AND MP.organization_id = MI.organization_id
764: AND MI.inventory_item_id = c_inventory_item_id
765: AND MI.organization_id = c_inventory_org_id
766: AND MI.enabled_flag = 'Y'
905: AND MI.enabled_flag = 'Y'
906: AND upper(MP.ORGANIZATION_CODE)=upper(c_org_code)
907: AND SYSDATE BETWEEN NVL( MI.start_date_active, SYSDATE )
908: AND NVL( MI.end_date_active, SYSDATE )
909: AND DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y';
910: */
911: /*
912: SELECT DISTINCT
913: mtl.INVENTORY_ITEM_ID ,
917: , MTL_PARAMETERS MP
918: , MTL_PARAMETERS MP1
919: , fnd_lookup_values_vl IT
920: where
921: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
922: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
923: and MP.MASTER_ORGANIZATION_ID = MP1.ORGANIZATION_ID
924: and sysdate between nvl( MTL.start_date_active, sysdate )
925: and nvl( MTL.end_date_active, sysdate )
955: AND MI.organization_id = c_inventory_org_id
956: AND MI.enabled_flag = 'Y'
957: AND SYSDATE BETWEEN NVL( MI.start_date_active, SYSDATE )
958: AND NVL( MI.end_date_active, SYSDATE )
959: AND DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y';
960: */
961: /*SELECT DISTINCT
962: mtl.INVENTORY_ITEM_ID ,
963: mtl.organization_id ,
965: from MTL_SYSTEM_ITEMS_KFV MTL
966: , MTL_PARAMETERS MP
967: , fnd_lookup_values_vl IT
968: where
969: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'
970: AND MTL.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
971: and sysdate between nvl( MTL.start_date_active, sysdate )
972: and nvl( MTL.end_date_active, sysdate )
973: and IT.lookup_code (+) = MTL.item_type
3583: FND_MSG_PUB.add;
3584: RETURN;
3585: END IF;
3586:
3587: AHL_UTIL_PKG.get_appln_usage
3588: (
3589: x_appln_code => l_appln_code,
3590: x_return_status => x_return_status
3591: );