DBA Data[Home] [Help]

APPS.OKS_IB_UTIL_PVT dependencies on JTF_RS_RESOURCE_EXTNS_TL

Line 60: jtf_rs_resource_extns_tl rsctl, --Bug Fix #5456468 Dneetha

56: SELECT rsctl.resource_name NAME,
57: NULL phone,
58: srp.email_address email
59: FROM jtf_rs_resource_extns rsc,
60: jtf_rs_resource_extns_tl rsctl, --Bug Fix #5456468 Dneetha
61: jtf_rs_salesreps srp
62: WHERE rsc.CATEGORY = 'OTHER'
63: AND srp.resource_id = rsc.resource_id
64: AND srp.org_id = p_org_id

Line 135: JTF_RS_RESOURCE_EXTNS_tl RSCTL ,-- Bug Fix #5456468 dneetha

131: SELECT
132: RSCTL.Resource_name name, null phone ,srp.email_address email
133: FROM
134: JTF_RS_RESOURCE_EXTNS RSC ,
135: JTF_RS_RESOURCE_EXTNS_tl RSCTL ,-- Bug Fix #5456468 dneetha
136: JTF_RS_SALESREPS SRP
137: WHERE
138: RSC.CATEGORY IN ('EMPLOYEE','OTHER','PARTY','PARTNER','SUPPLIER_CONTACT')
139: AND SRP.RESOURCE_ID = RSC.RESOURCE_ID