DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on GMD_PARAMETERS_HDR

Line 1543: -- to stop FTS on gmd_parameters_hdr

1539: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1540:
1541: -- bug 4924483 sql id 14687134 MJC take out org_access_view as not used in query
1542: -- bug 5223014 - sql id 17532478 NO change required as added created an index on Organization_Id
1543: -- to stop FTS on gmd_parameters_hdr
1544: CURSOR c_orgn_plant ( p_organization_id IN NUMBER) IS
1545: SELECT 1
1546: FROM
1547: -- org_access_view o,

Line 1549: gmd_parameters_hdr h

1545: SELECT 1
1546: FROM
1547: -- org_access_view o,
1548: mtl_parameters m,
1549: gmd_parameters_hdr h
1550: WHERE h.organization_id = m.organization_id
1551: AND m.process_enabled_flag = 'Y'
1552: AND m.organization_id = p_organization_id ;
1553: -- AND h.lab_ind = 1; -- FP For bug 7419838