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.GMPRELAP dependencies on GMD_RECIPE_VALIDITY_RULES

Line 513: (select inventory_item_id , recipe_validity_rule_id , DETAIL_UOM from gmd_recipe_validity_rules ) gmd

509: -- Bug: 8625112 Vpedarla
510: CURSOR Cur_get_item_uoms IS
511: SELECT msi.PRIMARY_UOM_CODE , gmd.detail_uom from
512: (select PRIMARY_UOM_CODE, inventory_item_id , organization_id from mtl_system_items) msi,
513: (select inventory_item_id , recipe_validity_rule_id , DETAIL_UOM from gmd_recipe_validity_rules ) gmd
514: where msi.organization_id = p_organization_id
515: AND msi.inventory_item_id = p_inventory_item_id
516: AND msi.inventory_item_id = gmd.inventory_item_id
517: AND gmd.recipe_validity_rule_id = p_effectivity_id ;

Line 946: gmd_recipe_validity_rules grv,

942: -- B5259453, FPO can use planning and production validity rules
943: CURSOR Cur_get_eff_id IS
944: SELECT gr.recipe_id, count(1)
945: FROM gmd_recipes_b gr,
946: gmd_recipe_validity_rules grv,
947: gmd_status_b gs
948: WHERE grv.validity_rule_status in ('700','900')
949: AND gr.recipe_id = grv.recipe_id
950: AND grv.validity_rule_status = gs.status_code

Line 1093: gmd_recipe_validity_rules b

1089: SELECT a.batch_no, a.batch_type, a.batch_status,
1090: a.plan_start_date, a.plan_cmplt_date,
1091: a.recipe_validity_rule_id, b.recipe_id
1092: FROM gme_batch_header a,
1093: gmd_recipe_validity_rules b
1094: WHERE a.batch_id = p_batch_id
1095: AND a.organization_id = p_organization_id
1096: AND a.recipe_validity_rule_id = b.recipe_validity_rule_id
1097: AND b.delete_mark = 0

Line 1145: (select inventory_item_id , recipe_validity_rule_id , DETAIL_UOM from gmd_recipe_validity_rules ) gmd

1141: -- Bug: 8663941 Vpedarla
1142: CURSOR Cur_get_item_uoms(eff_id NUMBER) IS
1143: SELECT msi.CONCATENATED_SEGMENTS , msi.inventory_item_id from
1144: (select PRIMARY_UOM_CODE, inventory_item_id , organization_id , CONCATENATED_SEGMENTS from mtl_system_items_kfv) msi,
1145: (select inventory_item_id , recipe_validity_rule_id , DETAIL_UOM from gmd_recipe_validity_rules ) gmd
1146: where msi.organization_id = p_organization_id
1147: AND msi.inventory_item_id = gmd.inventory_item_id
1148: AND gmd.recipe_validity_rule_id = eff_id ;
1149: