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 694: cursor get_batch_id_for_activity is select batch_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;

690: l_batch_id number;
691:
692: cursor get_batch_id_for_step is select batch_id from gme_batch_steps where batchstep_id = p_entity_key;
693: cursor get_batch_id_for_resource is select batch_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
694: cursor get_batch_id_for_activity is select batch_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
695: cursor get_batch_id_for_material is select batch_id from gme_material_details where material_detail_id = p_entity_key;
696:
697: NO_BATCH_FOUND_ERR exception;
698:

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

781: l_batchstep_id number;
782: l_batch_operation varchar2(1000);
783:
784: cursor get_batchstep_id_for_resource is select batchstep_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
785: cursor get_batchstep_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
786: cursor get_batchstep_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;
787:
788: NO_BATCHSTEP_FOUND_ERR exception;
789:

Line 912: 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;

908: l_msg_data varchar2(4000);
909: l_task varchar2(500);
910: l_task_id number;
911:
912: 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;
913: cursor get_min_activity is select min(batchstep_activity_id) from gme_batch_step_activities where batchstep_id = l_batchstep_id;
914:
915: 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;
916: cursor get_min_resource is select min(batchstep_resource_id) from gme_batch_step_resources where batchstep_activity_id = l_batchstep_activity_id;

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

909: l_task varchar2(500);
910: l_task_id number;
911:
912: 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;
913: cursor get_min_activity is select min(batchstep_activity_id) from gme_batch_step_activities where batchstep_id = l_batchstep_id;
914:
915: 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;
916: cursor get_min_resource is select min(batchstep_resource_id) from gme_batch_step_resources where batchstep_activity_id = l_batchstep_activity_id;
917:

Line 1163: from gme_batch_step_activities gbsa,

1159: select batchstep_activity_id,
1160: routingstep_id,
1161: oprn_line_id ,
1162: activity
1163: from gme_batch_step_activities gbsa,
1164: gme_batch_steps gbs
1165: where gbsa.batchstep_id = gbs.batchstep_id and gbsa.batch_id = p_entity_key;
1166:
1167: cursor c_get_resources is

Line 1174: gme_batch_step_Activities gbsa,

1170: oprn_line_id,
1171: resources ,
1172: gbsa.activity || '-' || resources
1173: from gme_batch_step_resources gbsr,
1174: gme_batch_step_Activities gbsa,
1175: gme_batch_steps gbs
1176: where gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
1177: and gbsa.batchstep_id = gbs.batchstep_id and gbsr.batch_id = p_entity_key;
1178:

Line 1555: 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;

1551: l_context_params_rec_type GMO_DATATYPES_GRP.CONTEXT_PARAMS_REC_TYPE;
1552:
1553: cursor get_step_detail is select batch_id, batchstep_id from gme_batch_steps where batchstep_id = l_batchstep_id;
1554:
1555: 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;
1556: 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;
1557:
1558: 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;
1559: 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 1556: 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;

1552:
1553: cursor get_step_detail is select batch_id, batchstep_id from gme_batch_steps where batchstep_id = l_batchstep_id;
1554:
1555: 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;
1556: 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;
1557:
1558: 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;
1559: 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;
1560:

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

2065: instruction_nullify_err exception;
2066:
2067: cursor c_get_steps is select batchstep_id from gme_batch_steps where batch_id = p_entity_key;
2068:
2069: cursor c_get_activities is select batchstep_activity_id from gme_batch_step_activities where batch_id = p_entity_key;
2070:
2071: cursor c_get_resources is select batchstep_resource_id from gme_batch_step_resources where batch_id = p_entity_key;
2072:
2073: cursor c_get_materials is select material_detail_id from gme_material_details where batch_id = p_entity_key;

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

2072:
2073: cursor c_get_materials is select material_detail_id from gme_material_details where batch_id = p_entity_key;
2074:
2075:
2076: cursor c_get_step_activities is select batchstep_activity_id from gme_batch_step_activities where batchstep_id = p_entity_key;
2077: cursor c_get_step_resources is select batchstep_resource_id from gme_batch_step_resources where batchstep_id = p_entity_key;
2078:
2079: cursor c_get_step_material is select material_detail_id from gme_batch_step_items where batchstep_id = p_entity_key;
2080:

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

2698: cursor is_step_locked is select count(*) from gmo_batch_step_lock_details where batchstep_id = l_batchstep_id;
2699: 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;
2700:
2701: cursor get_step_id_for_resource is select batchstep_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
2702: cursor get_step_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
2703: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;
2704:
2705: cursor get_step_detail is select step_status from gme_batch_steps where batchstep_id = l_batchstep_id;
2706:

Line 2870: gme_batch_step_activities where batchstep_id=P_BATCHSTEP_ID and batch_id =

2866: gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and
2867: batchstep_id= P_BATCHSTEP_ID and batch_id = P_BATCH_ID;
2868:
2869: cursor c_get_activity is select activity, batchstep_activity_id from
2870: gme_batch_step_activities where batchstep_id=P_BATCHSTEP_ID and batch_id =
2871: P_BATCH_ID;
2872:
2873: cursor c_get_resource is select resources, batchstep_resource_id from
2874: gme_batch_step_resources where batchstep_id=P_BATCHSTEP_ID and batch_id =

Line 3066: from gme_batch_step_activities gbsa,

3062: select batchstep_activity_id,
3063: routingstep_id,
3064: oprn_line_id ,
3065: activity
3066: from gme_batch_step_activities gbsa,
3067: gme_batch_steps gbs
3068: where gbsa.batchstep_id = gbs.batchstep_id and gbsa.batch_id = p_entity_key;
3069:
3070: cursor c_get_resources is

Line 3077: gme_batch_step_Activities gbsa,

3073: oprn_line_id,
3074: resources ,
3075: gbsa.activity || '-' || resources
3076: from gme_batch_step_resources gbsr,
3077: gme_batch_step_Activities gbsa,
3078: gme_batch_steps gbs
3079: where gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
3080: and gbsa.batchstep_id = gbs.batchstep_id and gbsr.batch_id = p_entity_key;
3081: