102: INTO MASTER_ORG_NAME
103: FROM
104: ORG_ORGANIZATION_DEFINITIONS2 ORG,
105: MTL_PARAMETERS MTL,
106: MFG_LOOKUPS A
107: WHERE NVL(ORG.DISABLE_DATE
108: ,SYSDATE + 1) > sysdate
109: AND ( ( MTL.ORGANIZATION_ID = MTL.MASTER_ORGANIZATION_ID ) )
110: AND mtl.organization_id (+) = ORG.ORGANIZATION_ID