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 843: 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

839: and nvl(uom_code, l_uom_code) = l_uom_code
840: and nvl(uom_class, l_uom_class) = l_uom_class
841: and nvl(effective_from,to_date('01011900','ddmmyyyy')) <= trunc(sysdate)
842: and nvl(effective_to,to_date('31124000','ddmmyyyy')) >= trunc(sysdate)
843: 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
844: and decode(category_id,null,'N', 'Y') = decode(category_id,null,'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_rec_mtrl.organization_id,
845: l_rec_mtrl.inventory_item_id,
846: category_set_id,
847: category_id )

Line 1339: 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

1335: and nvl(uom_code, l_uom_code) = l_uom_code
1336: and nvl(uom_class, l_uom_class) = l_uom_class
1337: and nvl(effective_from,to_date('01011900','ddmmyyyy')) <= trunc(sysdate)
1338: and nvl(effective_to,to_date('31124000','ddmmyyyy')) >= trunc(sysdate)
1339: 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
1340: and decode(category_id,null, 'N', 'Y') = decode(category_id, null, 'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_from_organization_id, -- 14071820
1341: l_rec_mtrl.inventory_item_id ,
1342: category_set_id,
1343: category_id ))