eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_STATUSES_PKG dependencies on AS_SALES_LEADS

Line 672: Create_Temp_Index('AS_SALES_LEADS','SALES_LEAD_ID,STATUS_CODE,CLOSE_REASON',G_INDEX_SUFFIX1);

668: -- Load the schema name first
669: Load_Schema_Name;
670:
671: --Create temporary indexes for leads
672: Create_Temp_Index('AS_SALES_LEADS','SALES_LEAD_ID,STATUS_CODE,CLOSE_REASON',G_INDEX_SUFFIX1);
673: Create_Temp_Index('AS_ACCESSES_ALL_ALL','ACCESS_ID,DELETE_FLAG,SALES_LEAD_ID',G_INDEX_SUFFIX1);
674:
675: --Create temporary indexes for opportunities
676: Create_Temp_Index('AS_LEADS_ALL','LEAD_ID,STATUS,CLOSE_REASON',G_INDEX_SUFFIX2);

Line 697: Drop_Temp_Index('AS_SALES_LEADS',G_INDEX_SUFFIX1);

693: ERRBUF OUT NOCOPY VARCHAR2,
694: RETCODE OUT NOCOPY VARCHAR2) IS
695: BEGIN
696: -- Drop temporary index for Leads
697: Drop_Temp_Index('AS_SALES_LEADS',G_INDEX_SUFFIX1);
698: Drop_Temp_Index('AS_ACCESSES_ALL_ALL',G_INDEX_SUFFIX1);
699:
700: -- Drop temporary index for Opportunities
701: Drop_Temp_Index('AS_LEADS_ALL',G_INDEX_SUFFIX2);

Line 1173: ( SELECT /+ INDEX(slds AS_SALES_LEADS_MT1)/ 1

1169: WHERE acc.ACCESS_ID >= l_count
1170: AND acc.ACCESS_ID < l_count+G_BATCH_SIZE
1171: AND acc.ACCESS_ID < l_max_id
1172: AND (l_lead_flag = 'Y' AND EXISTS
1173: ( SELECT /*+ INDEX(slds AS_SALES_LEADS_MT1)*/ 1
1174: FROM AS_SALES_LEADS slds
1175: WHERE slds.sales_lead_id = acc.sales_lead_id
1176: AND slds.status_code = X_STATUS_CODE
1177: AND acc.sales_lead_id is not null )

Line 1174: FROM AS_SALES_LEADS slds

1170: AND acc.ACCESS_ID < l_count+G_BATCH_SIZE
1171: AND acc.ACCESS_ID < l_max_id
1172: AND (l_lead_flag = 'Y' AND EXISTS
1173: ( SELECT /*+ INDEX(slds AS_SALES_LEADS_MT1)*/ 1
1174: FROM AS_SALES_LEADS slds
1175: WHERE slds.sales_lead_id = acc.sales_lead_id
1176: AND slds.status_code = X_STATUS_CODE
1177: AND acc.sales_lead_id is not null )
1178: )

Line 1202: acc.OPEN_FLAG = (SELECT /+ INDEX(slds AS_SALES_LEADS_MT1)/ st.opp_open_status_flag

1198:
1199: ELSE
1200: UPDATE /*+ INDEX(acc AS_ACCESSES_ALL_ALL_MT1)*/ AS_ACCESSES_ALL acc
1201: SET object_version_number = nvl(object_version_number,0) + 1,
1202: acc.OPEN_FLAG = (SELECT /*+ INDEX(slds AS_SALES_LEADS_MT1)*/ st.opp_open_status_flag
1203: FROM AS_STATUSES_B st,AS_SALES_LEADS slds
1204: WHERE st.status_code = slds.status_code
1205: AND slds.sales_lead_id = acc.sales_lead_id
1206: AND acc.sales_lead_id is not null

Line 1203: FROM AS_STATUSES_B st,AS_SALES_LEADS slds

1199: ELSE
1200: UPDATE /*+ INDEX(acc AS_ACCESSES_ALL_ALL_MT1)*/ AS_ACCESSES_ALL acc
1201: SET object_version_number = nvl(object_version_number,0) + 1,
1202: acc.OPEN_FLAG = (SELECT /*+ INDEX(slds AS_SALES_LEADS_MT1)*/ st.opp_open_status_flag
1203: FROM AS_STATUSES_B st,AS_SALES_LEADS slds
1204: WHERE st.status_code = slds.status_code
1205: AND slds.sales_lead_id = acc.sales_lead_id
1206: AND acc.sales_lead_id is not null
1207: AND st.lead_flag = 'Y'),

Line 1312: select AS_SALES_LEADS_S.nextval

1308: l_end_id NUMBER;
1309: l_batch_size CONSTANT NUMBER := 10000;
1310:
1311: CURSOR Get_SL_Next_Val IS
1312: select AS_SALES_LEADS_S.nextval
1313: from dual;
1314:
1315: CURSOR Get_SL_Min_Id IS
1316: select min(sales_lead_id)

Line 1317: from as_sales_leads;

1313: from dual;
1314:
1315: CURSOR Get_SL_Min_Id IS
1316: select min(sales_lead_id)
1317: from as_sales_leads;
1318:
1319: BEGIN
1320:
1321: --

Line 1582: from as_sales_leads;

1578:
1579:
1580: CURSOR Get_SL_Min_Id IS
1581: select min(sales_lead_id)
1582: from as_sales_leads;
1583:
1584: CURSOR Get_SL_Next_Val IS
1585: select AS_SALES_LEADS_S.nextval
1586: from dual;

Line 1585: select AS_SALES_LEADS_S.nextval

1581: select min(sales_lead_id)
1582: from as_sales_leads;
1583:
1584: CURSOR Get_SL_Next_Val IS
1585: select AS_SALES_LEADS_S.nextval
1586: from dual;
1587:
1588: CURSOR Get_flag_from_Input(c_in_param_1 VARCHAR2,c_in_param_2 VARCHAR2) IS
1589: select NVL(LEAD_FLAG,'N')

Line 1652: UPDATE /+ INDEX(sld AS_SALES_LEADS_MT1)/ AS_SALES_LEADS sld

1648: end if;
1649: -- update statements for sales leads here
1650: If Upper(X_STATUS_CODE) = 'ALL' THEN
1651: -- added decode for converted_to_opportunity fix for bug#3931530
1652: UPDATE /*+ INDEX(sld AS_SALES_LEADS_MT1)*/ AS_SALES_LEADS sld
1653: SET (sld.STATUS_OPEN_FLAG , sld.CLOSE_REASON) =
1654: (SELECT opp_open_status_flag,
1655: DECODE(opp_open_status_flag,'Y',NULL,'N',
1656: DECODE(st.status_code,'CONVERTED_TO_OPPORTUNITY','CONVERTED_TO_OPPORTUNITY',

Line 1672: UPDATE /+ INDEX(sld AS_SALES_LEADS_MT1)/ AS_SALES_LEADS sld

1668: AND sld.sales_lead_id < l_max_id
1669: AND sld.status_code is not null;
1670: ELSE
1671: -- added decode for converted_to_opportunity fix for bug#3931530
1672: UPDATE /*+ INDEX(sld AS_SALES_LEADS_MT1)*/ AS_SALES_LEADS sld
1673: SET sld.STATUS_OPEN_FLAG = Upper(X_OPEN_FLAG)
1674: , sld.CLOSE_REASON = DECODE(Upper(X_OPEN_FLAG),'Y',NULL,'N',
1675: DECODE(X_STATUS_CODE,'CONVERTED_TO_OPPORTUNITY','CONVERTED_TO_OPPORTUNITY',
1676: NVL(sld.close_reason,'NOT_SPECIFIED')