APPS.GME_GANTT_PKG dependencies on GME_BATCH_HEADER

Line 75: -- FROM gme_batch_header b

71: -- ,
72: -- --Bug#2479773 Swapna Kommineni 02-FEB-2005
73: -- NVL (finite_scheduled_ind, 0),
74: -- NVL(parentline_id,0) --Bug#5550337
75: -- FROM gme_batch_header b
76: -- WHERE organization_id = p_organization_id
77: -- --Bug#4867640 check for batch_no within the given range
78: -- AND ((p_to_batch_no IS NULL AND batch_no LIKE p_batch_no) OR
79: -- (lpad(batch_no,32,'0') >= lpad(p_batch_no,32,'0') AND

Line 170: -- FROM gme_batch_header b

166: -- ,
167: -- --Bug#2479773 Swapna Kommineni 02-FEB-2005
168: -- NVL (finite_scheduled_ind, 0),
169: -- NVL(parentline_id,0) --Bug#5550337
170: -- FROM gme_batch_header b
171: -- WHERE organization_id = p_organization_id
172: -- AND ((p_to_batch_no IS NULL AND batch_no LIKE p_batch_no) OR
173: -- (lpad(batch_no,32,'0') >= lpad(p_batch_no,32,'0') AND
174: -- lpad(batch_no,32,'0') <= lpad(p_to_batch_no,32,'0') )

Line 216: ,gme_batch_header b

212: CURSOR get_product_info (p_batch_id NUMBER)
213: IS
214: SELECT i.inventory_item_id, i.concatenated_segments, i.description
215: FROM mtl_system_items_kfv i
216: ,gme_batch_header b
217: ,gmd_recipe_validity_rules v
218: WHERE b.batch_id = p_batch_id
219: AND b.recipe_validity_rule_id = v.recipe_validity_rule_id
220: AND v.inventory_item_id = i.inventory_item_id

Line 227: ,gme_batch_header b

223: CURSOR get_product_info_lcf (p_batch_id NUMBER)
224: IS
225: SELECT i.inventory_item_id, i.concatenated_segments, i.description
226: FROM mtl_system_items_kfv i
227: ,gme_batch_header b
228: ,gme_material_details m
229: WHERE b.batch_id = p_batch_id
230: AND b.batch_id = m.batch_id
231: AND m.organization_id = i.organization_id

Line 334: l_column_select_str3 VARCHAR2(200) := ' NVL(TERMINATED_IND, 0) TERMINATED_IND , NVL(FINITE_SCHEDULED_IND, 0) FINITE_SCHEDULED_IND, NVL(PARENTLINE_ID,0) PARENTLINE_ID FROM GME_BATCH_HEADER B ';

330: l_query_count NUMBER := 0;
331:
332: l_column_select_str1 VARCHAR2(200) := ' SELECT B.BATCH_ID BATCH_ID, B.BATCH_NO BATCH_NO, BATCH_STATUS, BATCH_TYPE, PLAN_START_DATE, ACTUAL_START_DATE, ';
333: l_column_select_str2 VARCHAR2(200) := ' ACTUAL_CMPLT_DATE, PLAN_CMPLT_DATE, B.FORMULA_ID FORMULA_ID, NVL(ROUTING_ID, 0) ROUTING_ID, NVL(ENFORCE_STEP_DEPENDENCY, 0) ENFORCE_STEP_DEPENDENCY, ';
334: l_column_select_str3 VARCHAR2(200) := ' NVL(TERMINATED_IND, 0) TERMINATED_IND , NVL(FINITE_SCHEDULED_IND, 0) FINITE_SCHEDULED_IND, NVL(PARENTLINE_ID,0) PARENTLINE_ID FROM GME_BATCH_HEADER B ';
335: l_column_select_str4 VARCHAR2(200) := ' WHERE organization_id = :p_organization_id AND ';
336: l_column_select_str5 VARCHAR2(200) := NULL;
337: BEGIN
338: IF p_to_batch_no IS NULL THEN

Line 1310: ,gme_batch_header b

1306: ,NVL (r.terminated_ind, 0)
1307: FROM gme_batch_steps r
1308: ,gme_batch_step_resources d
1309: ,gmd_operations o
1310: ,gme_batch_header b
1311: WHERE r.batch_id = p_batch_id
1312: AND r.batch_id = d.batch_id
1313: AND r.batch_id = b.batch_id
1314: AND r.oprn_id = o.oprn_id

Line 1478: ,gme_batch_header b

1474: FROM gme_batch_step_resources o
1475: ,gme_batch_steps r
1476: ,gme_batch_step_activities s
1477: ,gmd_activities a
1478: ,gme_batch_header b
1479: ,cm_alys_mst c
1480: WHERE o.batch_id = p_batch_id
1481: AND r.batch_id = o.batch_id
1482: AND s.batch_id = r.batch_id

Line 1649: ,gme_batch_header b

1645: FROM gme_batch_steps r
1646: ,gme_batch_step_activities a
1647: ,gme_batch_step_resources o
1648: ,gmd_operations f
1649: ,gme_batch_header b
1650: ,cr_rsrc_mst c
1651: WHERE r.batch_id = p_batch_id
1652: AND b.batch_id = r.batch_id
1653: AND r.batchstep_no = p_batchstep_no

Line 1791: FROM gme_batch_header b, gmd_recipe_validity_rules v

1787: CURSOR get_ids (p_batch_id NUMBER)
1788: IS
1789: SELECT b.formula_id, b.routing_id, b.recipe_validity_rule_id
1790: ,v.recipe_id
1791: FROM gme_batch_header b, gmd_recipe_validity_rules v
1792: WHERE b.batch_id = p_batch_id
1793: AND b.recipe_validity_rule_id = v.recipe_validity_rule_id(+);
1794:
1795: CURSOR get_routing_info (p_routing_id NUMBER)