APPS.GMD_STATUS_PUB dependencies on GMD_ROUTINGS_B

Line 169: FROM gmd_routings_b

165: CURSOR get_curr_routing_status(vrouting_id NUMBER
166: ,vrouting_no VARCHAR2
167: ,vrouting_vers NUMBER) IS
168: SELECT routing_id, routing_no, routing_vers, routing_status
169: FROM gmd_routings_b
170: WHERE ((vrouting_no IS NULL AND vrouting_vers IS NULL) AND
171: (routing_id = vrouting_id)) OR
172: ((vrouting_id IS NULL) AND
173: (routing_no = vrouting_no AND routing_vers = vrouting_vers));

Line 941: 'ROUTING','GMD_ROUTINGS_B',

937: SELECT DECODE(P_entity_name,
938: 'FORMULA','FM_FORM_MST_B',
939: 'RECIPE','GMD_RECIPES_B',
940: 'OPERATION','GMD_OPERATIONS_B',
941: 'ROUTING','GMD_ROUTINGS_B',
942: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES') INTO l_table_name
943: FROM sys.dual;
944: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
945: 'TABLE_NAME',l_table_name,