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.GME_GANTT_PKG dependencies on GME_BATCH_HEADER

Line 53: FROM gme_batch_header b

49: ,
50: --Bug#2479773 Swapna Kommineni 02-FEB-2005
51: NVL (finite_scheduled_ind, 0),
52: NVL(parentline_id,0) --Bug#5550337
53: FROM gme_batch_header b
54: WHERE organization_id = p_organization_id
55: --Bug#4867640 check for batch_no within the given range
56: AND ((p_to_batch_no IS NULL AND batch_no LIKE p_batch_no) OR
57: (lpad(batch_no,32,'0') >= lpad(p_batch_no,32,'0') AND

Line 127: FROM gme_batch_header b

123: ,
124: --Bug#2479773 Swapna Kommineni 02-FEB-2005
125: NVL (finite_scheduled_ind, 0),
126: NVL(parentline_id,0) --Bug#5550337
127: FROM gme_batch_header b
128: WHERE organization_id = p_organization_id
129: AND ((p_to_batch_no IS NULL AND batch_no LIKE p_batch_no) OR
130: (lpad(batch_no,32,'0') >= lpad(p_batch_no,32,'0') AND
131: lpad(batch_no,32,'0') <= lpad(p_to_batch_no,32,'0') )

Line 173: ,gme_batch_header b

169: CURSOR get_product_info (p_batch_id NUMBER)
170: IS
171: SELECT i.inventory_item_id, i.concatenated_segments, i.description
172: FROM mtl_system_items_kfv i
173: ,gme_batch_header b
174: ,gmd_recipe_validity_rules v
175: WHERE b.batch_id = p_batch_id
176: AND b.recipe_validity_rule_id = v.recipe_validity_rule_id
177: AND v.inventory_item_id = i.inventory_item_id

Line 184: ,gme_batch_header b

180: CURSOR get_product_info_lcf (p_batch_id NUMBER)
181: IS
182: SELECT i.inventory_item_id, i.concatenated_segments, i.description
183: FROM mtl_system_items_kfv i
184: ,gme_batch_header b
185: ,gme_material_details m
186: WHERE b.batch_id = p_batch_id
187: AND b.batch_id = m.batch_id
188: AND m.organization_id = i.organization_id

Line 821: ,gme_batch_header b

817: ,NVL (r.terminated_ind, 0)
818: FROM gme_batch_steps r
819: ,gme_batch_step_resources d
820: ,gmd_operations o
821: ,gme_batch_header b
822: WHERE r.batch_id = p_batch_id
823: AND r.batch_id = d.batch_id
824: AND r.batch_id = b.batch_id
825: AND r.oprn_id = o.oprn_id

Line 989: ,gme_batch_header b

985: FROM gme_batch_step_resources o
986: ,gme_batch_steps r
987: ,gme_batch_step_activities s
988: ,gmd_activities a
989: ,gme_batch_header b
990: ,cm_alys_mst c
991: WHERE o.batch_id = p_batch_id
992: AND r.batch_id = o.batch_id
993: AND s.batch_id = r.batch_id

Line 1159: ,gme_batch_header b

1155: FROM gme_batch_steps r
1156: ,gme_batch_step_activities a
1157: ,gme_batch_step_resources o
1158: ,gmd_operations f
1159: ,gme_batch_header b
1160: ,cr_rsrc_mst c
1161: WHERE r.batch_id = p_batch_id
1162: AND b.batch_id = r.batch_id
1163: AND r.batchstep_no = p_batchstep_no

Line 1301: FROM gme_batch_header b, gmd_recipe_validity_rules v

1297: CURSOR get_ids (p_batch_id NUMBER)
1298: IS
1299: SELECT b.formula_id, b.routing_id, b.recipe_validity_rule_id
1300: ,v.recipe_id
1301: FROM gme_batch_header b, gmd_recipe_validity_rules v
1302: WHERE b.batch_id = p_batch_id
1303: AND b.recipe_validity_rule_id = v.recipe_validity_rule_id(+);
1304:
1305: CURSOR get_routing_info (p_routing_id NUMBER)