DBA Data[Home] [Help]

APPS.GME_GANTT_RSRC_PKG dependencies on GME_BATCH_HEADER

Line 127: ,gme_batch_header b

123: CURSOR get_product_info (p_batch_id NUMBER)
124: IS
125: SELECT i.inventory_item_id, i.concatenated_segments
126: FROM mtl_system_items_kfv i --Bug#5550337 changed from ic_item_mst
127: ,gme_batch_header b
128: ,gmd_recipe_validity_rules v
129: WHERE b.batch_id = p_batch_id
130: AND b.recipe_validity_rule_id = v.recipe_validity_rule_id
131: AND v.inventory_item_id = i.inventory_item_id;

Line 165: FROM gme_batch_header b

161: /*,DECODE (b.batch_status
162: ,1, b.plan_start_date
163: ,b.actual_start_date) start_date */
164: ,b.plan_cmplt_date, NVL (b.enforce_step_dependency, 0)
165: FROM gme_batch_header b
166: WHERE b.organization_id = p_organization_id
167: AND b.parentline_id IS NULL --Bug#5550337 not showing phantom batches as we cant reschedule
168: AND b.batch_status IN (1, 2)
169: AND ( ( b.plan_start_date >= p_from_date