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.BIC_SUMMARY_EXTRACT_PKG dependencies on BIC_PARTY_SUMMARY

Line 1320: insert into bic_party_summary (

1316: g_proc_name_old := g_proc_name;
1317: g_proc_name := 'Retention_churned';
1318: debug(' entered +');
1319: --g_tot_recs_added := 0;
1320: insert into bic_party_summary (
1321: MEASURE_ID
1322: ,PARTY_ID --CUSTOMER_ID
1323: ,PERIOD_START_DATE
1324: ,VALUE

Line 1354: from bic_party_summary psum

1350: ,g_program_id
1351: ,sysdate
1352: ,null
1353: ,'RETENTION'
1354: from bic_party_summary psum
1355: where psum.period_start_date
1356: between add_months(g_period_start_date,g_attrition_period*-1)
1357: and add_months(g_period_end_date,g_attrition_period*-1)
1358:

Line 1360: and not exists ( select 1 from bic_party_summary psum_in

1356: between add_months(g_period_start_date,g_attrition_period*-1)
1357: and add_months(g_period_end_date,g_attrition_period*-1)
1358:
1359: and measure_id = g_measure_id_for_retn
1360: and not exists ( select 1 from bic_party_summary psum_in
1361: where psum_in.measure_id = g_measure_id_for_retn
1362: and psum_in.party_id = psum.party_id
1363: and psum_in.period_start_date =
1364: add_months(psum.period_start_date,g_attrition_period)

Line 1396: insert into bic_party_summary (

1392: fetch party_cur into x_party_id, x_account_established_date;
1393: if party_cur % notfound then
1394: exit;
1395: end if;
1396: insert into bic_party_summary (
1397: MEASURE_ID
1398: ,PARTY_ID
1399: ,PERIOD_START_DATE
1400: ,VALUE

Line 1496: insert into bic_party_summary (

1492: if party_cur % notfound then
1493: exit;
1494: end if;
1495: -- raise no_data_found;
1496: insert into bic_party_summary (
1497: MEASURE_ID
1498: ,PARTY_ID
1499: ,PERIOD_START_DATE
1500: ,VALUE

Line 1604: insert into bic_party_summary (

1600: if party_cur % notfound then
1601: exit;
1602: end if;
1603:
1604: insert into bic_party_summary (
1605: MEASURE_ID
1606: ,PARTY_ID
1607: ,PERIOD_START_DATE
1608: ,VALUE

Line 2031: insert into bic_party_summary ( --bic_customer_summary_all (

2027: exit;
2028: end if;
2029: -- BEGIN
2030: -- SAVEPOINT start_transaction;
2031: insert into bic_party_summary ( --bic_customer_summary_all (
2032: measure_id,
2033: party_id, --customer_id,
2034: period_start_date,
2035: value,

Line 2088: insert into bic_party_summary (measure_id ,

2084: write_log('Before Activation Extraction...');
2085: -- A acquired customer can be considered activated
2086: -- only in the month in which the first order is made and the first order should
2087: -- be within the activation period and also within the start and end dates of extraction
2088: insert into bic_party_summary (measure_id ,
2089: party_id ,
2090: period_start_date ,
2091: value ,
2092: last_update_date ,

Line 2118: bic_party_summary bcs,

2114: g_program_id,
2115: g_last_update_login,
2116: 'ACTIVATION'
2117: from oe_order_headers_all aoh, --4434468 replaced aso_i_oe_order_headers_v with oe_order_headers_all
2118: bic_party_summary bcs,
2119: hz_cust_accounts acct
2120: where bcs.measure_id = g_measure_id_for_acqu
2121:
2122: --and to_date(bcs.value + g_activation_period ,'J') >= g_period_start_date