APPS.GMD_API_GRP dependencies on FM_FORM_MST_B

Line 599: FROM fm_form_mst_b a, mtl_parameters b

595: BEGIN
596: IF (Entity = 'FORMULA') THEN
597: SELECT b.organization_code, b.organization_id
598: INTO l_owner_orgn_code, l_orgn_id
599: FROM fm_form_mst_b a, mtl_parameters b
600: WHERE a.formula_id = Entity_id
601: AND a.owner_organization_id = b.organization_id;
602:
603: /* Check if user has access to this formula orgn */

Line 771: FROM fm_form_mst_b f,gmd_Status_b s

767: l_status_type GMD_STATUS_B.status_type%TYPE;
768:
769: CURSOR Cur_get_fsttyp(pobject_id NUMBER) IS
770: SELECT s.status_type
771: FROM fm_form_mst_b f,gmd_Status_b s
772: WHERE f.formula_id = pobject_id AND
773: f.formula_status = s.status_code;
774:
775: CURSOR Cur_get_rsttyp(pobject_id NUMBER) IS

Line 961: FROM fm_form_mst_b

957: IF (vEntity_id IS NOT NULL) THEN
958: IF (vEntity = 'FORMULA') THEN
959: Select formula_no, formula_vers, formula_no||' - '||formula_vers
960: INTO l_object_name, l_object_version, l_object_name_and_version
961: FROM fm_form_mst_b
962: WHere formula_id = vEntity_id;
963: ELSIF (vEntity = 'ROUTING') THEN
964: Select routing_no, routing_vers, routing_no||' - '||routing_vers
965: INTO l_object_name, l_object_version, l_object_name_and_version

Line 1454: FROM fm_form_mst_b

1450: FROM FND_DUAL;
1451:
1452: CURSOR c_get_formula IS
1453: SELECT creation_date, formula_status, owner_organization_id
1454: FROM fm_form_mst_b
1455: WHERE formula_id = p_formula_id;
1456: LocalDateRecord c_get_formula%ROWTYPE;
1457:
1458: CURSOR c_get_formula_item IS

Line 1664: FROM fm_form_mst_b

1660: -- Cursors
1661: CURSOR c_get_formula_info IS
1662: SELECT formula_no, formula_vers, formula_desc1,
1663: owner_organization_id, formula_status, owner_id
1664: FROM fm_form_mst_b
1665: WHERE formula_id = p_formula_id;
1666: LocalFormRecord c_get_formula_info%ROWTYPE;
1667:
1668: -- Kapil LCF-GMO ME : Bug#5458666