APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on JTF_RS_SALESREPS_MO_V

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

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

Line 268: FROM JTF_RS_SALESREPS_MO_V

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

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

3666:
3667: CURSOR salesrep( p_resource_id NUMBER) IS
3668: select salesrep_id
3669: /* from jtf_rs_srp_vl */ --Commented Code Yogeshwar (MOAC)
3670: from jtf_rs_salesreps_mo_v --New Code Yogeshwar (MOAC)
3671: where resource_id = p_resource_id ;
3672: /*
3673: and NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
3674: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(

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

4295:
4296: CURSOR salesrep( p_resource_id NUMBER) IS
4297: select salesrep_id
4298: -- from jtf_rs_srp_vl Commented Code Yogeshwar (MOAC)
4299: from jtf_rs_salesreps_mo_v --New Code Yogeshwar (MOAC)
4300: where resource_id = p_resource_id ;
4301: --Commented Code Start Yogeshwar (MOAC)
4302: /*
4303: and NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), '',