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.WMS_RULES_WORKBENCH_PVT dependencies on WMS_DATECHECK_PVT

Line 737: and wms_datecheck_pvt.date_valid(l_from_organization_id,date_type_code,date_type_from,date_type_to,effective_from,effective_to) = 'Y' --Added bug 4081657

733: and nvl(uom_code, l_uom_code) = l_uom_code
734: and nvl(uom_class, l_uom_class) = l_uom_class
735: and nvl(effective_from,to_date('01011900','ddmmyyyy')) <= trunc(sysdate)
736: and nvl(effective_to,to_date('31124000','ddmmyyyy')) >= trunc(sysdate)
737: and wms_datecheck_pvt.date_valid(l_from_organization_id,date_type_code,date_type_from,date_type_to,effective_from,effective_to) = 'Y' --Added bug 4081657
738: and decode(category_id,null,'N', 'Y') = decode(category_id,null,'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_rec_mtrl.organization_id,
739: l_rec_mtrl.inventory_item_id,
740: category_set_id,
741: category_id )

Line 1143: and wms_datecheck_pvt.date_valid(l_from_organization_id,date_type_code,date_type_from,date_type_to,effective_from,effective_to) = 'Y' --Added bug 4081657

1139: and nvl(uom_code, l_uom_code) = l_uom_code
1140: and nvl(uom_class, l_uom_class) = l_uom_class
1141: and nvl(effective_from,to_date('01011900','ddmmyyyy')) <= trunc(sysdate)
1142: and nvl(effective_to,to_date('31124000','ddmmyyyy')) >= trunc(sysdate)
1143: and wms_datecheck_pvt.date_valid(l_from_organization_id,date_type_code,date_type_from,date_type_to,effective_from,effective_to) = 'Y' --Added bug 4081657
1144: and decode(category_id,null, 'N', 'Y') = decode(category_id, null, 'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_rec_mtrl.organization_id,
1145: l_rec_mtrl.inventory_item_id ,
1146: category_set_id,
1147: category_id ))