DBA Data[Home] [Help]

APPS.GMO_CBR_GRP dependencies on GMO_MATERIAL_UNDISPENSES

Line 417: FROM gmo_material_undispenses

413: FROM gmo_material_dispenses
414: WHERE dispense_id = l_dispense_id;
415: CURSOR get_rev_dispense_Details IS
416: SELECT batch_id, batch_step_id ,material_detail_id,dispense_id
417: FROM gmo_material_undispenses
418: WHERE undispense_id = l_event_key;
419: CURSOR GET_LABEL_DETAILS IS
420: SELECT entity_name, entity_key
421: from gmo_label_history

Line 1442: FROM gmo_material_undispenses

1438: FROM gmo_material_dispenses
1439: WHERE dispense_id = p_entity_key;
1440: CURSOR get_rev_dispense_Details IS
1441: SELECT batch_id, batch_step_id ,material_detail_id,dispense_id
1442: FROM gmo_material_undispenses
1443: WHERE undispense_id = p_entity_key;
1444: CURSOR get_resource_details IS
1445: SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_ACTIVITY_ID FROM GME_BATCH_STEP_RESOURCES
1446: where BATCHSTEP_RESOURCE_ID = p_entity_key;