DBA Data[Home] [Help]

APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on JTF_RS_SALESREPS

Line 1005: , jtf_rs_salesreps res

1001: AND h.buy_or_sell ='S'
1002: AND h.scs_code IN ('SERVICE','WARRANTY')
1003: GROUP BY srep.dnz_chr_id, h.authoring_org_id
1004: )srep
1005: , jtf_rs_salesreps res
1006: WHERE 1=1
1007: AND fsp.org_id = h.authoring_org_id
1008: AND sob.set_of_books_id = fsp.set_of_books_id
1009: AND h.id = sh.chr_id

Line 1306: (select resource_id from jtf_rs_salesreps s where s.salesrep_id = new.salesrep_id

1302: , batch_id
1303: , grace_end_date
1304: , salesrep_id
1305: , CASE WHEN SALESREP_ID <> -1 THEN
1306: (select resource_id from jtf_rs_salesreps s where s.salesrep_id = new.salesrep_id
1307: and s.org_id = new.authoring_org_id)
1308: END resource_id
1309: , resource_group_id
1310: , -1 worker_number