APPS.OKS_IB_UTIL_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 32: FROM jtf_rs_resource_extns rsc,

28: CURSOR party_contact_kadmin IS
29: SELECT c.last_name || ' ' || c.first_name NAME,
30: c.phone,
31: c.email_address email
32: FROM jtf_rs_resource_extns rsc,
33: ap_supplier_sites_all pvs,
34: hz_party_sites hps,
35: hz_locations hl,
36: po_vendor_contacts c

Line 49: FROM jtf_rs_resource_extns rsc,

45: UNION ALL
46: SELECT emp.full_name NAME,
47: emp.work_telephone phone,
48: emp.email_address email
49: FROM jtf_rs_resource_extns rsc,
50: per_all_people_f emp
51: WHERE rsc.CATEGORY = 'EMPLOYEE'
52: AND emp.person_id = rsc.source_id
53: AND rsc.resource_id = TO_NUMBER (p_object1_id1)

Line 59: FROM jtf_rs_resource_extns rsc,

55: UNION ALL
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

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 77: FROM jtf_rs_resource_extns rsc,

73: SELECT party.party_name NAME,
74: party.primary_phone_area_code || '-' || party.primary_phone_number
75: phone,
76: party.email_address email
77: FROM jtf_rs_resource_extns rsc,
78: hz_parties party
79: WHERE rsc.CATEGORY IN ('PARTY', 'PARTNER')
80: AND party.party_id = rsc.source_id
81: AND rsc.resource_id = TO_NUMBER (p_object1_id1)

Line 90: JTF_RS_RESOURCE_EXTNS RSC ,

86: /* Share memory issue
87: CURSOR party_contact_kadmin IS
88: SELECT C.LAST_NAME ||' '||c.first_name name, c.phone, c.email_address email
89: FROM
90: JTF_RS_RESOURCE_EXTNS RSC ,
91: PO_VENDOR_SITES_ALL S ,
92: PO_VENDOR_CONTACTS C
93: WHERE
94: RSC.CATEGORY = 'SUPPLIER_CONTACT'

Line 102: FROM JTF_RS_RESOURCE_EXTNS RSC ,

98: AND RSC.RESOURCE_ID = to_number(p_object1_id1)
99: AND '#' = p_object1_id2
100: UNION ALL
101: SELECT EMP.FULL_NAME name , emp.work_telephone phone ,emp.email_address email
102: FROM JTF_RS_RESOURCE_EXTNS RSC ,
103: PER_ALL_PEOPLE_F EMP
104: WHERE
105: RSC.CATEGORY = 'EMPLOYEE'
106: AND EMP.PERSON_ID = RSC.SOURCE_ID

Line 113: JTF_RS_RESOURCE_EXTNS RSC ,

109: UNION ALL
110: SELECT
111: SRP.NAME name, null phone ,srp.email_address email
112: FROM
113: JTF_RS_RESOURCE_EXTNS RSC ,
114: JTF_RS_SALESREPS SRP
115: WHERE
116: RSC.CATEGORY = 'OTHER'
117: AND SRP.RESOURCE_ID = RSC.RESOURCE_ID

Line 123: FROM JTF_RS_RESOURCE_EXTNS RSC ,HZ_PARTIES PARTY

119: AND RSC.RESOURCE_ID = to_number(p_object1_id1)
120: AND '#' = p_object1_id2
121: UNION ALL
122: SELECT party.party_name name, party.primary_phone_area_code ||'-'||party.primary_phone_number phone ,party.email_address email
123: FROM JTF_RS_RESOURCE_EXTNS RSC ,HZ_PARTIES PARTY
124: WHERE RSC.CATEGORY IN ( 'PARTY', 'PARTNER')
125: AND PARTY.PARTY_ID = RSC.SOURCE_ID
126: AND RSC.RESOURCE_ID = to_number(p_object1_id1)
127: AND '#' = p_object1_id2 ;

Line 134: JTF_RS_RESOURCE_EXTNS RSC ,

130: CURSOR party_contact_salesrep IS
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')

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

Line 363: , jtf_rs_resource_extns_vl v

359:
360: Cursor l_salesrep_csr Is
361: Select v.resource_name sales_person
362: From jtf_rs_salesreps jtf
363: , jtf_rs_resource_extns_vl v
364: , okc_contacts oc1
365: ,Okc_k_headers_all_b kh
366:
367: Where oc1.dnz_chr_id = P_contract_id