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.GMDRPGAP_WF_PKG dependencies on FM_FORM_MST

Line 27: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;

23: l_owner_id GMD_RECIPES.OWNER_ID%TYPE;
24: /* Krishna Prasad , Modified added orgn_id for WF Convergence */
25: l_creation_orgn_code ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
26: l_creation_orgn_id GMD_RECIPES.creation_organization_id%TYPE;
27: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
28: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
29: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
30: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
31: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;

Line 29: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;

25: l_creation_orgn_code ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
26: l_creation_orgn_id GMD_RECIPES.creation_organization_id%TYPE;
27: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
28: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
29: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
30: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
31: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
32: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
33: /* Mercy Thomas Bug 3173515 End of the changes */

Line 30: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;

26: l_creation_orgn_id GMD_RECIPES.creation_organization_id%TYPE;
27: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
28: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
29: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
30: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
31: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
32: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
33: /* Mercy Thomas Bug 3173515 End of the changes */
34:

Line 102: FROM GMD_RECIPES A, GMD_ROUTINGS B, FM_FORM_MST C

98:
99: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
100: SELECT A.RECIPE_DESCRIPTION, A.OWNER_ID, A.CREATION_ORGANIZATION_ID, C.FORMULA_NO, C.FORMULA_VERS, B.ROUTING_NO, B.ROUTING_VERS
101: INTO l_recipe_description, l_owner_id, l_creation_orgn_id, l_formula_no, l_formula_vers, l_routing_no, l_routing_vers
102: FROM GMD_RECIPES A, GMD_ROUTINGS B, FM_FORM_MST C
103: WHERE A.RECIPE_ID = P_RECIPE_ID
104: AND A.ROUTING_ID = B.ROUTING_ID (+)
105: AND A.FORMULA_ID = C.FORMULA_ID;
106:

Line 287: FROM gmd_recipes_b r, fm_form_mst_b f

283: l_orgn_id NUMBER;
284:
285: CURSOR c_get_details IS
286: SELECT r.owner_organization_id, r.formula_id, r.recipe_no, r.recipe_version
287: FROM gmd_recipes_b r, fm_form_mst_b f
288: WHERE r.recipe_id = l_recipe_id
289: AND r.formula_id = f.formula_id;
290: LocalDetailsRecord c_get_details%ROWTYPE;
291: