DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on GMD_PARAMETERS_HDR

Line 1584: -- to stop FTS on gmd_parameters_hdr

1580: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1581:
1582: -- bug 4924483 sql id 14687134 MJC take out org_access_view as not used in query
1583: -- bug 5223014 - sql id 17532478 NO change required as added created an index on Organization_Id
1584: -- to stop FTS on gmd_parameters_hdr
1585: CURSOR c_orgn_plant ( p_organization_id IN NUMBER) IS
1586: SELECT 1
1587: FROM
1588: -- org_access_view o,

Line 1590: gmd_parameters_hdr h

1586: SELECT 1
1587: FROM
1588: -- org_access_view o,
1589: mtl_parameters m,
1590: gmd_parameters_hdr h
1591: WHERE h.organization_id = m.organization_id
1592: AND m.process_enabled_flag = 'Y'
1593: AND m.organization_id = p_organization_id;
1594: -- AND h.lab_ind = 1; /* Commented in Bug No. 7419838 */