APPS.ISC_DBI_BSA_OBJECTS_C dependencies on ISC_DBI_BSA_ORDER_LINES_F

Line 503: bis_collection_utilities.put_line('Inserting data into isc_dbi_bsa_order_lines_f');

499:
500: begin
501:
502: bis_collection_utilities.put_line(' ');
503: bis_collection_utilities.put_line('Inserting data into isc_dbi_bsa_order_lines_f');
504: fii_util.start_timer;
505:
506: insert /*+ APPEND PARALLEL(F) */ into isc_dbi_bsa_order_lines_f f (
507: order_line_id,

Line 506: insert /*+ APPEND PARALLEL(F) */ into isc_dbi_bsa_order_lines_f f (

502: bis_collection_utilities.put_line(' ');
503: bis_collection_utilities.put_line('Inserting data into isc_dbi_bsa_order_lines_f');
504: fii_util.start_timer;
505:
506: insert /*+ APPEND PARALLEL(F) */ into isc_dbi_bsa_order_lines_f f (
507: order_line_id,
508: order_line_header_id,
509: order_number,
510: line_number,

Line 626: fii_util.print_timer('Inserted '|| l_bsa_count ||' rows into isc_dbi_bsa_order_lines_f in');

622: and tmp.sold_to_org_id = cust_acct.cust_account_id;
623:
624: l_bsa_count := sql%rowcount;
625: fii_util.stop_timer;
626: fii_util.print_timer('Inserted '|| l_bsa_count ||' rows into isc_dbi_bsa_order_lines_f in');
627:
628: commit;
629:
630: return(l_bsa_count);

Line 720: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';

716: bis_collection_utilities.put_line(' ');
717: bis_collection_utilities.put_line('Truncating the fact tables');
718: fii_util.start_timer;
719:
720: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';
721:
722: fii_util.stop_timer;
723: fii_util.print_timer('Truncated the fact tables in');
724: g_row_count := 0;

Line 747: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';

743: bis_collection_utilities.put_line(' ');
744: bis_collection_utilities.put_line('Truncating the fact tables');
745: fii_util.start_timer;
746:
747: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';
748:
749: fii_util.stop_timer;
750: fii_util.print_timer('Truncated the fact tables in');
751:

Line 1157: from isc_dbi_bsa_order_lines_f f,

1153: order_line_id
1154: from (select f.blanket_line_id,
1155: t.order_line_id,
1156: rank() over (partition by f.blanket_line_id order by t.order_line_id) rnk
1157: from isc_dbi_bsa_order_lines_f f,
1158: isc_dbi_tmp_bsa_order_lines t
1159: where f.blanket_line_id = t.blanket_line_id
1160: and f.order_line_id is null
1161: and t.order_line_id is not null)

Line 1177: update isc_dbi_bsa_order_lines_f

1173: fetch unfulfilled_bsa into l_record;
1174:
1175: if unfulfilled_bsa%rowcount <> 0 then
1176: while unfulfilled_bsa%found loop
1177: update isc_dbi_bsa_order_lines_f
1178: set order_line_id = l_record.order_line_id
1179: where blanket_line_id = l_record.blanket_line_id;
1180: fetch unfulfilled_bsa into l_record;
1181: end loop;

Line 1195: merge into isc_dbi_bsa_order_lines_f f using

1191: bis_collection_utilities.put_line('Merging batch '||v_batch_id);
1192:
1193: l_count := 0;
1194:
1195: merge into isc_dbi_bsa_order_lines_f f using
1196: (select new.*
1197: from (select tmp.batch_id,
1198: tmp.order_line_id,
1199: tmp.order_line_header_id,

Line 1267: and tmp.sold_to_org_id = cust_acct.cust_account_id) new, isc_dbi_bsa_order_lines_f old

1263: and tmp.time_activation_date_id = curr.conversion_date
1264: and tmp.salesrep_id = sg.salesrep_id
1265: and tmp.org_id = sg.org_id
1266: and tmp.h_start_date_active between sg.start_date and sg.end_date
1267: and tmp.sold_to_org_id = cust_acct.cust_account_id) new, isc_dbi_bsa_order_lines_f old
1268: where new.batch_id = v_batch_id
1269: and new.blanket_line_id = old.blanket_line_id(+)
1270: and nvl(new.order_line_id,-1) = nvl(old.order_line_id(+),-1)
1271: and (old.blanket_line_id is null