APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on JTF_RS_SALESREPS_MO_V

Line 254: from jtf_rs_salesreps_mo_v --New Code Yogeshwar (MOAC)

250:
251: CURSOR salesrep( p_resource_id NUMBER) IS
252: select salesrep_id
253: /* from jtf_rs_srp_vl */ --Commented Code Yogeshwar (MOAC)
254: from jtf_rs_salesreps_mo_v --New Code Yogeshwar (MOAC)
255: where resource_id = p_resource_id ;
256: --Commented code Start Yogeshwar (MOAC)
257: /*
258: and NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',

Line 266: FROM JTF_RS_SALESREPS_MO_V

262: --Commented Code End Yogeshwar (MOAC)
263:
264: CURSOR C_Get_Srep_From_Snumber( lc_srep_num VARCHAR2) IS
265: SELECT Salesrep_Id
266: FROM JTF_RS_SALESREPS_MO_V
267: WHERE Salesrep_Number = lc_srep_num
268: AND NVL(status,'A') = 'A'
269: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
270: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate) ;

Line 3614: from jtf_rs_salesreps_mo_v --New Code Yogeshwar (MOAC)

3610:
3611: CURSOR salesrep( p_resource_id NUMBER) IS
3612: select salesrep_id
3613: /* from jtf_rs_srp_vl */ --Commented Code Yogeshwar (MOAC)
3614: from jtf_rs_salesreps_mo_v --New Code Yogeshwar (MOAC)
3615: where resource_id = p_resource_id ;
3616: /*
3617: and NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
3618: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(

Line 4232: from jtf_rs_salesreps_mo_v --New Code Yogeshwar (MOAC)

4228:
4229: CURSOR salesrep( p_resource_id NUMBER) IS
4230: select salesrep_id
4231: -- from jtf_rs_srp_vl Commented Code Yogeshwar (MOAC)
4232: from jtf_rs_salesreps_mo_v --New Code Yogeshwar (MOAC)
4233: where resource_id = p_resource_id ;
4234: --Commented Code Start Yogeshwar (MOAC)
4235: /*
4236: and NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), '',