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 1378: FROM gmo_material_undispenses

1374: FROM gmo_material_dispenses
1375: WHERE dispense_id = p_entity_key;
1376: CURSOR get_rev_dispense_Details IS
1377: SELECT batch_id, batch_step_id ,material_detail_id,dispense_id
1378: FROM gmo_material_undispenses
1379: WHERE undispense_id = p_entity_key;
1380: CURSOR get_resource_details IS
1381: SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_ACTIVITY_ID FROM GME_BATCH_STEP_RESOURCES
1382: where BATCHSTEP_RESOURCE_ID = p_entity_key;