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.BIM_I_LEAD_FACTS_PKG dependencies on BIM_I_LEAD_FACTS_STG

Line 22: FROM bim_i_lead_facts_stg

18: CURSOR C_missing_rates
19: IS
20: SELECT from_currency from_currency,
21: decode(conversion_rate,-3,to_date('01/01/1999','MM/DD/RRRR'),lead_creation_date) lead_creation_date
22: FROM bim_i_lead_facts_stg
23: WHERE (conversion_rate < 0
24: OR conversion_rate IS NULL)
25: AND from_currency is not null
26: AND lead_creation_date >= p_start_date

Line 30: SELECT COUNT(*) INTO l_cnt_miss_rate FROM bim_i_lead_facts_stg

26: AND lead_creation_date >= p_start_date
27: ORDER BY from_currency;
28: BEGIN
29: l_msg_name := 'BIS_DBI_CURR_NO_LOAD';
30: SELECT COUNT(*) INTO l_cnt_miss_rate FROM bim_i_lead_facts_stg
31: WHERE
32: (conversion_rate < 0
33: OR conversion_rate IS NULL)
34: AND from_currency is not null

Line 349: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts_stg';

345: /* Dropping INdexes */
346: BIM_UTL_PKG.DROP_INDEX('BIM_I_LEAD_FACTS');
347:
348: /* Truncate Staging table */
349: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts_stg';
350:
351:
352: l_table_name := 'BIM_I_LEAD_FACTS';
353: bis_collection_utilities.log('Running Initial Load of Lead Facts');

Line 358: INTO bim_i_lead_facts_stg LDF

354:
355: l_sysdate :=sysdate;
356:
357: INSERT /*+ append parallel */
358: INTO bim_i_lead_facts_stg LDF
359: (
360: lead_id
361: ,lead_line_id
362: ,group_id

Line 451: l_stmt := 'TRUNCATE table '||l_schema||'.bim_i_lead_facts_stg';

447:
448: /*l_check_missing_rate := Check_Missing_Rates (p_start_date);
449: if (l_check_missing_rate = -1) then
450: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
451: l_stmt := 'TRUNCATE table '||l_schema||'.bim_i_lead_facts_stg';
452: EXECUTE IMMEDIATE l_stmt;
453: commit;
454:
455: x_return_status := FND_API.G_RET_STS_ERROR;

Line 462: /*update bim.bim_i_lead_facts_stg stg

458: */
459:
460: --update to get customer category
461:
462: /*update bim.bim_i_lead_facts_stg stg
463: set stg.cust_category
464: = (select b.class_code from hz_code_assignments b
465: where
466: stg.customer_id=b.OWNER_TABLE_ID

Line 484: update bim_i_lead_facts_stg stg

480: and b.CLASS_CATEGORY='CUSTOMER_CATEGORY'
481: and b.status='A');
482: */
483:
484: update bim_i_lead_facts_stg stg
485: set stg.cust_category
486: = (select b.class_code from hz_code_assignments b
487: where
488: stg.customer_id=b.OWNER_TABLE_ID

Line 529: UPDATE bim_i_lead_facts_stg stg SET CUSTOMER_FLAG='Y'

525:
526:
527: IF l_cert_level = 'YES' THEN
528:
529: UPDATE bim_i_lead_facts_stg stg SET CUSTOMER_FLAG='Y'
530: WHERE
531: EXISTS
532: (SELECT 1 from HZ_CUST_ACCOUNTS a,hz_parties b
533: WHERE a.party_id=stg.customer_id

Line 540: UPDATE bim_i_lead_facts_stg stg set CUSTOMER_FLAG='Y'

536: AND b.certification_level is not null);
537:
538: ELSE
539:
540: UPDATE bim_i_lead_facts_stg stg set CUSTOMER_FLAG='Y'
541: WHERE
542: EXISTS
543: (SELECT 1 from HZ_CUST_ACCOUNTS a
544: WHERE a.party_id=stg.customer_id

Line 660: bim_i_lead_facts_stg X

656: ,nvl(x.product_category_id,-1) product_category_id
657: ,x.customer_flag customer_flag
658: ,x.lead_name Lead_name
659: FROM
660: bim_i_lead_facts_stg X
661: ,bim_i_source_codes A
662: ,bis_territory_hierarchies T
663: WHERE
664: X.source_code_id = A.source_code_id(+)

Line 752: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts_stg';

748:
749:
750:
751:
752: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts_stg';
753:
754: --EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.mlog$_bim_i_lead_facts';
755:
756: --dbms_output.put_line(p_start_date);

Line 906: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts_stg';

902: l_table_name := 'BIM_I_LEAD_FACTS';
903: bis_collection_utilities.log('Running Incremental Load of Lead Facts');
904:
905: /* Truncate Staging table */
906: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts_stg';
907:
908: l_sysdate:=sysdate;
909:
910: INSERT /*+ append parallel */

Line 911: INTO bim_i_lead_facts_stg LDF

907:
908: l_sysdate:=sysdate;
909:
910: INSERT /*+ append parallel */
911: INTO bim_i_lead_facts_stg LDF
912: (
913: lead_id
914: ,group_id
915: ,resource_id

Line 982: INTO bim_i_lead_facts_stg LDF

978:
979: COMMIT;
980:
981: INSERT /*+ append parallel */
982: INTO bim_i_lead_facts_stg LDF
983: (
984: lead_id
985: ,lead_line_id
986: ,group_id

Line 1072: l_stmt := 'TRUNCATE table '||l_schema||'.bim_i_lead_facts_stg';

1068:
1069: /*l_check_missing_rate := Check_Missing_Rates (p_start_date);
1070: if (l_check_missing_rate = -1) then
1071: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
1072: l_stmt := 'TRUNCATE table '||l_schema||'.bim_i_lead_facts_stg';
1073: EXECUTE IMMEDIATE l_stmt;
1074: commit;
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1082: update bim_i_lead_facts_stg stg

1078: */
1079:
1080: --update to get customer category
1081:
1082: update bim_i_lead_facts_stg stg
1083: set stg.cust_category
1084: = (select b.class_code from hz_code_assignments b
1085: where
1086: stg.customer_id=b.OWNER_TABLE_ID

Line 1126: update bim_i_lead_facts_stg stg set CUSTOMER_FLAG='Y'

1122: --update customer flag
1123:
1124: IF l_cert_level = 'YES' THEN
1125:
1126: update bim_i_lead_facts_stg stg set CUSTOMER_FLAG='Y'
1127: where
1128: exists
1129: (select 1 from HZ_CUST_ACCOUNTS a,hz_parties b
1130: where a.party_id=stg.customer_id

Line 1137: update bim_i_lead_facts_stg stg set CUSTOMER_FLAG='Y'

1133: and b.certification_level is not null);
1134:
1135: else
1136:
1137: update bim_i_lead_facts_stg stg set CUSTOMER_FLAG='Y'
1138: where
1139: exists
1140: (select 1 from HZ_CUST_ACCOUNTS a
1141: where a.party_id=stg.customer_id

Line 1201: bim_i_lead_facts_stg X

1197: ,nvl(x.product_category_id,-1) product_category_id
1198: ,x.customer_flag customer_flag
1199: ,x.lead_name lead_name
1200: FROM
1201: bim_i_lead_facts_stg X
1202: ,bim_i_source_codes A
1203: ,bis_territory_hierarchies T
1204: WHERE
1205: X.source_code_id = A.source_code_id(+)

Line 1472: FROM bim_i_lead_facts_stg

1468: FROM bim_i_lead_facts
1469: WHERE lead_line_id IS NULL
1470: AND lead_id in (SELECT
1471: lead_id
1472: FROM bim_i_lead_facts_stg
1473: WHERE lead_line_id is NOT NULL);
1474:
1475: COMMIT;
1476:

Line 1477: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts_stg';

1473: WHERE lead_line_id is NOT NULL);
1474:
1475: COMMIT;
1476:
1477: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts_stg';
1478:
1479:
1480: --dbms_output.put_line(p_start_date);
1481: --dbms_output.put_line(p_end_date);