DBA Data[Home] [Help]

APPS.JTY_ASSIGN_REALTIME_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 792: from jtf_rs_resource_extns_tl a

788: select a.resource_id resource_id, a.resource_name resource_name,
789: decode(a.category ,'EMPLOYEE', 'RS_EMPLOYEE','PARTNER', 'RS_PARTNER','SUPPLIER_CONTACT',
790: 'RS_SUPPLIER_CONTACT' , 'PARTY', 'RS_PARTY' , 'OTHER',
791: 'RS_OTHER', 'TBH', 'RS_TBH') RESOURCE_TYPE
792: from jtf_rs_resource_extns_tl a
793: where a.language = userenv('LANG')
794: ) rsv
795: , jtf_rs_resource_extns rsc
796: , jtf_rs_resource_extns mgr

Line 795: , jtf_rs_resource_extns rsc

791: 'RS_OTHER', 'TBH', 'RS_TBH') RESOURCE_TYPE
792: from jtf_rs_resource_extns_tl a
793: where a.language = userenv('LANG')
794: ) rsv
795: , jtf_rs_resource_extns rsc
796: , jtf_rs_resource_extns mgr
797: , jtf_rs_roles_vl role
798: WHERE WT.terr_id = jta.terr_id
799: AND WT.terr_id = jtr.terr_id

Line 796: , jtf_rs_resource_extns mgr

792: from jtf_rs_resource_extns_tl a
793: where a.language = userenv('LANG')
794: ) rsv
795: , jtf_rs_resource_extns rsc
796: , jtf_rs_resource_extns mgr
797: , jtf_rs_roles_vl role
798: WHERE WT.terr_id = jta.terr_id
799: AND WT.terr_id = jtr.terr_id
800: AND jtr.end_date_active >= WT.txn_date

Line 1864: from jtf_rs_resource_extns_tl a

1860: select a.resource_id resource_id, a.resource_name resource_name,
1861: decode(a.category ,'EMPLOYEE', 'RS_EMPLOYEE','PARTNER', 'RS_PARTNER','SUPPLIER_CONTACT',
1862: 'RS_SUPPLIER_CONTACT' , 'PARTY', 'RS_PARTY' , 'OTHER',
1863: 'RS_OTHER', 'TBH', 'RS_TBH') RESOURCE_TYPE
1864: from jtf_rs_resource_extns_tl a
1865: where a.language = userenv('LANG')
1866: ) rsv
1867: , jtf_rs_resource_extns rsc
1868: , jtf_rs_resource_extns mgr

Line 1867: , jtf_rs_resource_extns rsc

1863: 'RS_OTHER', 'TBH', 'RS_TBH') RESOURCE_TYPE
1864: from jtf_rs_resource_extns_tl a
1865: where a.language = userenv('LANG')
1866: ) rsv
1867: , jtf_rs_resource_extns rsc
1868: , jtf_rs_resource_extns mgr
1869: , jtf_rs_roles_vl role
1870: WHERE WINNERS.win_terr_id = jta.terr_id
1871: AND WINNERS.win_terr_id = jtr.terr_id

Line 1868: , jtf_rs_resource_extns mgr

1864: from jtf_rs_resource_extns_tl a
1865: where a.language = userenv('LANG')
1866: ) rsv
1867: , jtf_rs_resource_extns rsc
1868: , jtf_rs_resource_extns mgr
1869: , jtf_rs_roles_vl role
1870: WHERE WINNERS.win_terr_id = jta.terr_id
1871: AND WINNERS.win_terr_id = jtr.terr_id
1872: AND jtr.end_date_active >= WINNERS.txn_date