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.GMO_VBATCH_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 739: cursor get_batch_id_for_activity is select batch_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;

735: l_batch_id number;
736:
737: cursor get_batch_id_for_step is select batch_id from gme_batch_steps where batchstep_id = p_entity_key;
738: cursor get_batch_id_for_resource is select batch_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
739: cursor get_batch_id_for_activity is select batch_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
740: cursor get_batch_id_for_material is select batch_id from gme_material_details where material_detail_id = p_entity_key;
741:
742: NO_BATCH_FOUND_ERR exception;
743:

Line 830: cursor get_batchstep_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;

826: l_batchstep_id number;
827: l_batch_operation varchar2(1000);
828:
829: cursor get_batchstep_id_for_resource is select batchstep_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
830: cursor get_batchstep_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
831: cursor get_batchstep_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;
832:
833: NO_BATCHSTEP_FOUND_ERR exception;
834:

Line 957: cursor get_activity is select batchstep_activity_id from gme_batch_step_activities where batchstep_id = l_batchstep_id and oprn_line_id = l_oprn_line_id;

953: l_msg_data varchar2(4000);
954: l_task varchar2(500);
955: l_task_id number;
956:
957: cursor get_activity is select batchstep_activity_id from gme_batch_step_activities where batchstep_id = l_batchstep_id and oprn_line_id = l_oprn_line_id;
958: cursor get_min_activity is select min(batchstep_activity_id) from gme_batch_step_activities where batchstep_id = l_batchstep_id;
959:
960: cursor get_resource is select batchstep_resource_id from gme_batch_step_resources where batchstep_activity_id = l_batchstep_activity_id and resources = l_resources;
961: cursor get_min_resource is select min(batchstep_resource_id) from gme_batch_step_resources where batchstep_activity_id = l_batchstep_activity_id;

Line 958: cursor get_min_activity is select min(batchstep_activity_id) from gme_batch_step_activities where batchstep_id = l_batchstep_id;

954: l_task varchar2(500);
955: l_task_id number;
956:
957: cursor get_activity is select batchstep_activity_id from gme_batch_step_activities where batchstep_id = l_batchstep_id and oprn_line_id = l_oprn_line_id;
958: cursor get_min_activity is select min(batchstep_activity_id) from gme_batch_step_activities where batchstep_id = l_batchstep_id;
959:
960: cursor get_resource is select batchstep_resource_id from gme_batch_step_resources where batchstep_activity_id = l_batchstep_activity_id and resources = l_resources;
961: cursor get_min_resource is select min(batchstep_resource_id) from gme_batch_step_resources where batchstep_activity_id = l_batchstep_activity_id;
962:

Line 1208: from gme_batch_step_activities gbsa,

1204: select batchstep_activity_id,
1205: routingstep_id,
1206: oprn_line_id ,
1207: activity
1208: from gme_batch_step_activities gbsa,
1209: gme_batch_steps gbs
1210: where gbsa.batchstep_id = gbs.batchstep_id and gbsa.batch_id = p_entity_key;
1211:
1212: cursor c_get_resources is

Line 1219: gme_batch_step_Activities gbsa,

1215: oprn_line_id,
1216: resources ,
1217: gbsa.activity || '-' || resources
1218: from gme_batch_step_resources gbsr,
1219: gme_batch_step_Activities gbsa,
1220: gme_batch_steps gbs
1221: where gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
1222: and gbsa.batchstep_id = gbs.batchstep_id and gbsr.batch_id = p_entity_key;
1223:

Line 1600: cursor get_activity_detail is select batch_id, batchstep_id, batchstep_activity_id from gme_batch_step_activities where batchstep_id = l_batchstep_id and oprn_line_id = l_oprn_line_id;

1596: l_context_params_rec_type GMO_DATATYPES_GRP.CONTEXT_PARAMS_REC_TYPE;
1597:
1598: cursor get_step_detail is select batch_id, batchstep_id from gme_batch_steps where batchstep_id = l_batchstep_id;
1599:
1600: cursor get_activity_detail is select batch_id, batchstep_id, batchstep_activity_id from gme_batch_step_activities where batchstep_id = l_batchstep_id and oprn_line_id = l_oprn_line_id;
1601: cursor get_activity_detail_from_id is select batch_id, batchstep_id, batchstep_activity_id from gme_batch_step_activities where batchstep_activity_id = l_batchstep_activity_id;
1602:
1603: cursor get_resource_detail is select batch_id, batchstep_id, batchstep_activity_id, batchstep_resource_id from gme_batch_step_resources where batchstep_activity_id = l_batchstep_activity_id and resources = l_resources;
1604: cursor get_resource_detail_from_id is select batch_id, batchstep_id, batchstep_activity_id, batchstep_resource_id from gme_batch_step_resources where batchstep_resource_id = l_batchstep_resource_id;

Line 1601: cursor get_activity_detail_from_id is select batch_id, batchstep_id, batchstep_activity_id from gme_batch_step_activities where batchstep_activity_id = l_batchstep_activity_id;

1597:
1598: cursor get_step_detail is select batch_id, batchstep_id from gme_batch_steps where batchstep_id = l_batchstep_id;
1599:
1600: cursor get_activity_detail is select batch_id, batchstep_id, batchstep_activity_id from gme_batch_step_activities where batchstep_id = l_batchstep_id and oprn_line_id = l_oprn_line_id;
1601: cursor get_activity_detail_from_id is select batch_id, batchstep_id, batchstep_activity_id from gme_batch_step_activities where batchstep_activity_id = l_batchstep_activity_id;
1602:
1603: cursor get_resource_detail is select batch_id, batchstep_id, batchstep_activity_id, batchstep_resource_id from gme_batch_step_resources where batchstep_activity_id = l_batchstep_activity_id and resources = l_resources;
1604: cursor get_resource_detail_from_id is select batch_id, batchstep_id, batchstep_activity_id, batchstep_resource_id from gme_batch_step_resources where batchstep_resource_id = l_batchstep_resource_id;
1605:

Line 2114: cursor c_get_activities is select batchstep_activity_id from gme_batch_step_activities where batch_id = p_entity_key;

2110: instruction_nullify_err exception;
2111:
2112: cursor c_get_steps is select batchstep_id from gme_batch_steps where batch_id = p_entity_key;
2113:
2114: cursor c_get_activities is select batchstep_activity_id from gme_batch_step_activities where batch_id = p_entity_key;
2115:
2116: cursor c_get_resources is select batchstep_resource_id from gme_batch_step_resources where batch_id = p_entity_key;
2117:
2118: cursor c_get_materials is select material_detail_id from gme_material_details where batch_id = p_entity_key;

Line 2121: cursor c_get_step_activities is select batchstep_activity_id from gme_batch_step_activities where batchstep_id = p_entity_key;

2117:
2118: cursor c_get_materials is select material_detail_id from gme_material_details where batch_id = p_entity_key;
2119:
2120:
2121: cursor c_get_step_activities is select batchstep_activity_id from gme_batch_step_activities where batchstep_id = p_entity_key;
2122: cursor c_get_step_resources is select batchstep_resource_id from gme_batch_step_resources where batchstep_id = p_entity_key;
2123:
2124: cursor c_get_step_material is select material_detail_id from gme_batch_step_items where batchstep_id = p_entity_key;
2125:

Line 2747: cursor get_step_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;

2743: cursor is_step_locked is select count(*) from gmo_batch_step_lock_details where batchstep_id = l_batchstep_id;
2744: cursor is_step_locked_by is select count(*) from gmo_batch_step_lock_details where batchstep_id = l_batchstep_id and lock_requester = P_REQUESTER;
2745:
2746: cursor get_step_id_for_resource is select batchstep_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
2747: cursor get_step_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
2748: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;
2749:
2750: cursor get_step_detail is select step_status from gme_batch_steps where batchstep_id = l_batchstep_id;
2751:

Line 2915: gme_batch_step_activities where batchstep_id=P_BATCHSTEP_ID and batch_id =

2911: gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and
2912: batchstep_id= P_BATCHSTEP_ID and batch_id = P_BATCH_ID;
2913:
2914: cursor c_get_activity is select activity, batchstep_activity_id from
2915: gme_batch_step_activities where batchstep_id=P_BATCHSTEP_ID and batch_id =
2916: P_BATCH_ID;
2917:
2918: cursor c_get_resource is select resources, batchstep_resource_id from
2919: gme_batch_step_resources where batchstep_id=P_BATCHSTEP_ID and batch_id =

Line 3111: from gme_batch_step_activities gbsa,

3107: select batchstep_activity_id,
3108: routingstep_id,
3109: oprn_line_id ,
3110: activity
3111: from gme_batch_step_activities gbsa,
3112: gme_batch_steps gbs
3113: where gbsa.batchstep_id = gbs.batchstep_id and gbsa.batch_id = p_entity_key;
3114:
3115: cursor c_get_resources is

Line 3122: gme_batch_step_Activities gbsa,

3118: oprn_line_id,
3119: resources ,
3120: gbsa.activity || '-' || resources
3121: from gme_batch_step_resources gbsr,
3122: gme_batch_step_Activities gbsa,
3123: gme_batch_steps gbs
3124: where gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
3125: and gbsa.batchstep_id = gbs.batchstep_id and gbsr.batch_id = p_entity_key;
3126: