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.WIP_PROD_INDICATORS dependencies on WIP_BIS_PROD_DEPT_YIELD

Line 315: -- WIP_BIS_PROD_DEPT_YIELD

311:
312: -- Previously, the this program used to throw away all the existing
313: -- data in the tables:
314: -- WIP_BIS_PROD_INDICATORS
315: -- WIP_BIS_PROD_DEPT_YIELD
316: -- WIP_BIS_PROD_ASSY_YIELD
317: -- This has to be avoided now. So we are doing the following:
318: -- Each of these tables will be backed up into a temp table
319: -- The original tables will be truncated as before.

Line 484: -- the summary table wip_bis_prod_dept_yield

480: --dbms_output.put_line (to_char (sysdate, 'DD-MON-YYYY HH24:MI:SS'));
481: --dbms_output.put_line('Before Stage 6');
482:
483: -- Move the yield information for each department into the
484: -- the summary table wip_bis_prod_dept_yield
485: Move_Yield_Info(
486: p_group_id => x_group_id,
487: p_errnum => p_errnum,
488: p_errmesg => p_errmesg );

Line 557: -- 3. WIP_BIS_PROD_DEPT_YIELD

553:
554: -- Populate the denormalized information into the summary tables:
555: -- 1. WIP_BIS_PROD_INDICATORS
556: -- 2. WIP_BIS_PROD_ASSY_YIELD
557: -- 3. WIP_BIS_PROD_DEPT_YIELD
558: Populate_Denormalize_Data(p_errnum => p_errnum,
559: p_errmesg => p_errmesg );
560: commit;
561:

Line 569: -- and wip_bis_prod_dept_yield_v.

565:
566: -- Stage: 10.5
567: -- Update existing flag to 1 for all new rows because
568: -- that is the filtering criterion for wip_bis_prod_assy_yield_v
569: -- and wip_bis_prod_dept_yield_v.
570: -- Bugfix 3387800.
571:
572: if g_debug = 1 then
573: fnd_file.put_line (fnd_file.log,

Line 660: '.WIP_BIS_PROD_DEPT_YIELD';

656: execute immediate 'truncate table ' || g_wip_schema ||
657: '.WIP_BIS_PROD_INDICATORS';
658:
659: execute immediate 'truncate table ' || g_wip_schema ||
660: '.WIP_BIS_PROD_DEPT_YIELD';
661:
662: execute immediate 'truncate table ' || g_wip_schema ||
663: '.WIP_BIS_PROD_ASSY_YIELD';
664: -- keep data that is not part if this collection's date range

Line 3196: summary table wip_bis_prod_dept_yield.

3192:
3193:
3194: /* Move_Yield_Info
3195: Move the yield information for every department into the
3196: summary table wip_bis_prod_dept_yield.
3197: */
3198: PROCEDURE Move_Yield_Info (
3199: p_group_id IN NUMBER,
3200: p_errnum OUT NOCOPY NUMBER,

Line 3217: INSERT INTO wip_bis_prod_dept_yield (

3213: END IF ;
3214: ----dbms_output.put_line('Before Stage 6 Phase I');
3215:
3216: -- insert efficiency into the summary table
3217: INSERT INTO wip_bis_prod_dept_yield (
3218: ORGANIZATION_ID,
3219: WIP_ENTITY_ID,
3220: INVENTORY_ITEM_ID,
3221: TRANSACTION_DATE,

Line 3595: delete from wip_bis_prod_dept_yield

3591: to_char(x_org_id) || ' ' || substr(SQLERRM,1,105);
3592: Delete_Temp_Info(p_group_id=>p_group_Id);
3593: delete from wip_bis_prod_indicators
3594: where existing_flag is null ;
3595: delete from wip_bis_prod_dept_yield
3596: where existing_flag is null ;
3597: commit ;
3598: return ;
3599:

Line 3713: '.WIP_BIS_PROD_DEPT_YIELD';

3709: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3710: '.WIP_BIS_PROD_INDICATORS';
3711:
3712: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3713: '.WIP_BIS_PROD_DEPT_YIELD';
3714:
3715: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3716: '.WIP_BIS_PROD_ASSY_YIELD';
3717:

Line 5276: 2. Wip_bis_prod_dept_yield

5272: -- organization
5273: -- item
5274: -- time
5275: -- geographical location
5276: 2. Wip_bis_prod_dept_yield
5277: -- organization
5278: -- time
5279: -- geographical location
5280: (Note item is not denormalized here)

Line 5356: WIP_BIS_PROD_DEPT_YIELD

5352: p_errmesg => p_errmesg );
5353: commit;
5354:
5355: /**********************
5356: WIP_BIS_PROD_DEPT_YIELD
5357: **********************/
5358: -- do not denormalize the item information for departmentyYield
5359:
5360: x_phase := 'V';

Line 5366: p_table_name => 'wip_bis_prod_dept_yield',

5362: if g_debug = 1 then
5363: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN V');
5364: end if ;
5365: denormalize_org_dimension(
5366: p_table_name => 'wip_bis_prod_dept_yield',
5367: p_errnum => p_errnum,
5368: p_errmesg => p_errmesg );
5369: /* denormalize_time_dimension(
5370: p_table_name => 'wip_bis_prod_dept_yield',

Line 5370: p_table_name => 'wip_bis_prod_dept_yield',

5366: p_table_name => 'wip_bis_prod_dept_yield',
5367: p_errnum => p_errnum,
5368: p_errmesg => p_errmesg );
5369: /* denormalize_time_dimension(
5370: p_table_name => 'wip_bis_prod_dept_yield',
5371: p_errnum => p_errnum,
5372: p_errmesg => p_errmesg );*/
5373: commit;
5374:

Line 5381: p_table_name => 'wip_bis_prod_dept_yield',

5377: if g_debug = 1 then
5378: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN VI');
5379: end if ;
5380: denormalize_time_dimension(
5381: p_table_name => 'wip_bis_prod_dept_yield',
5382: p_errnum => p_errnum,
5383: p_errmesg => p_errmesg );
5384: /* denormalize_org_dimension(
5385: p_table_name => 'wip_bis_prod_dept_yield',

Line 5385: p_table_name => 'wip_bis_prod_dept_yield',

5381: p_table_name => 'wip_bis_prod_dept_yield',
5382: p_errnum => p_errnum,
5383: p_errmesg => p_errmesg );
5384: /* denormalize_org_dimension(
5385: p_table_name => 'wip_bis_prod_dept_yield',
5386: p_errnum => p_errnum,
5387: p_errmesg => p_errmesg );*/
5388: commit;
5389:

Line 5397: p_table_name => 'wip_bis_prod_dept_yield',

5393: fnd_file.put_line(fnd_file.log, 'Before Stage 10 Phase IN VII');
5394: end if ;
5395:
5396: denormalize_geo_dimension(
5397: p_table_name => 'wip_bis_prod_dept_yield',
5398: p_errnum => p_errnum,
5399: p_errmesg => p_errmesg );
5400: commit;
5401:

Line 6171: -- wip_bis_prod_assy_yield or wip_bis_prod_dept_yield tables.

6167: END simple_decomp;
6168:
6169: -- Following bug 3387800, check for the existing flag not being
6170: -- equal to 1 for any row in the wip_bis_prod_indicators,
6171: -- wip_bis_prod_assy_yield or wip_bis_prod_dept_yield tables.
6172: -- If it is not equal to 1, all existing data data should not
6173: -- be backed up.
6174: --
6175: -- Note that since the old program used to set the existing_flag to

Line 6201: FROM wip_bis_prod_dept_yield

6197: AND rownum < 2;
6198:
6199: CURSOR bad_existing_flag_wbpdy_csr IS
6200: SELECT 1
6201: FROM wip_bis_prod_dept_yield
6202: WHERE nvl (existing_flag, -1) <> 1
6203: AND rownum < 2;
6204:
6205:

Line 6249: -- WIP_BIS_PROD_DEPT_YIELD

6245:
6246: -- Create the 3 backup tables
6247: -- WIP_BIS_PROD_INDICATORS
6248: -- WIP_BIS_PROD_ASSY_YIELD
6249: -- WIP_BIS_PROD_DEPT_YIELD
6250: -- into three temp tables
6251: -- The three tables are backed up with data less than the specified
6252: -- date. This will take care of the fact that the present collection
6253: -- might overlap with the data already collected. In that case, we

Line 6267: l_wip_bis_prod_dept_yield NUMBER := 0;

6263: proc_name VARCHAR2(20);
6264:
6265: l_wip_bis_prod_indicators NUMBER := 0;
6266: l_wip_bis_prod_assy_yield NUMBER := 0;
6267: l_wip_bis_prod_dept_yield NUMBER := 0;
6268:
6269: BEGIN
6270: proc_name := 'backup_summary_table';
6271: -- clear garbage out of the tables.

Line 6285: SELECT count(1) INTO l_wip_bis_prod_dept_yield FROM wip_bis_prod_dept_yield;

6281: SELECT count(1) INTO l_wip_bis_prod_indicators FROM wip_bis_prod_indicators;
6282:
6283: SELECT count(1) INTO l_wip_bis_prod_assy_yield FROM wip_bis_prod_assy_yield;
6284:
6285: SELECT count(1) INTO l_wip_bis_prod_dept_yield FROM wip_bis_prod_dept_yield;
6286:
6287: -- RS: If summary tables don't have any data, it is assumed that the previous run failed at merge
6288: -- and data is present in temp tables. So, don't truncate or back up them in this run.
6289: -- Though this is an unusual case, its a difficult situation to get out as these temp tables

Line 6292: IF (l_wip_bis_prod_indicators <> 0 AND l_wip_bis_prod_assy_yield <> 0 AND l_wip_bis_prod_dept_yield <> 0) THEN

6288: -- and data is present in temp tables. So, don't truncate or back up them in this run.
6289: -- Though this is an unusual case, its a difficult situation to get out as these temp tables
6290: -- would be truncated in the next run, and customer will have to collect entire data again.
6291:
6292: IF (l_wip_bis_prod_indicators <> 0 AND l_wip_bis_prod_assy_yield <> 0 AND l_wip_bis_prod_dept_yield <> 0) THEN
6293:
6294: IF g_debug = 1 THEN
6295: fnd_file.put_line(fnd_file.log,'Backing up old data (if any)...');
6296: END IF ;

Line 6487: INSERT INTO wip_bis_prod_dept_yield_temp (

6483: FROM wip_bis_prod_assy_yield
6484: WHERE transaction_date < trunc (p_max_backup_date);
6485:
6486:
6487: INSERT INTO wip_bis_prod_dept_yield_temp (
6488: organization_id,
6489: wip_entity_id,
6490: inventory_item_id,
6491: operation_seq_num,

Line 6564: FROM wip_bis_prod_dept_yield

6560: period_set_name,
6561: year,
6562: quarter,
6563: month
6564: FROM wip_bis_prod_dept_yield
6565: WHERE transaction_date < trunc (p_max_backup_date);
6566:
6567: END IF;
6568:

Line 6600: wip_bis_prod_dept_yield

6596: /* Update the existing flag off all rows in
6597: in:
6598: wip_bis_prod_indicators
6599: wip_bis_prod_assy_yield
6600: wip_bis_prod_dept_yield
6601:
6602: This is for fixing bug 3387800 which causes various views
6603: on these tables to turn up empty.
6604:

Line 6621: UPDATE wip_bis_prod_dept_yield

6617:
6618: UPDATE wip_bis_prod_assy_yield
6619: SET existing_flag = 1;
6620:
6621: UPDATE wip_bis_prod_dept_yield
6622: SET existing_flag = 1;
6623:
6624: p_errnum := 0;
6625: p_errmesg := '';

Line 6839: INSERT INTO wip_bis_prod_dept_yield (

6835: quarter,
6836: month
6837: FROM wip_bis_prod_assy_yield_temp;
6838:
6839: INSERT INTO wip_bis_prod_dept_yield (
6840: organization_id,
6841: wip_entity_id,
6842: inventory_item_id,
6843: operation_seq_num,

Line 6916: FROM wip_bis_prod_dept_yield_temp;

6912: period_set_name,
6913: year,
6914: quarter,
6915: month
6916: FROM wip_bis_prod_dept_yield_temp;
6917:
6918: p_errnum := 0;
6919: p_errmesg := '';
6920:

Line 6940: '.WIP_BIS_PROD_DEPT_YIELD';

6936: execute immediate 'truncate table ' || g_wip_schema ||
6937: '.WIP_BIS_PROD_INDICATORS';
6938:
6939: execute immediate 'truncate table ' || g_wip_schema ||
6940: '.WIP_BIS_PROD_DEPT_YIELD';
6941:
6942: execute immediate 'truncate table ' || g_wip_schema ||
6943: '.WIP_BIS_PROD_ASSY_YIELD';
6944: raise; -- Added by Suhasini for bug 5132779

Line 6965: '.WIP_BIS_PROD_DEPT_YIELD_TEMP';

6961: proc_name := 'clear_temp_summary_tables';
6962: execute immediate 'truncate table ' || g_wip_schema ||
6963: '.WIP_BIS_PROD_INDICATORS_TEMP';
6964: execute immediate 'truncate table ' || g_wip_schema ||
6965: '.WIP_BIS_PROD_DEPT_YIELD_TEMP';
6966: execute immediate 'truncate table ' || g_wip_schema ||
6967: '.WIP_BIS_PROD_ASSY_YIELD_TEMP';
6968:
6969: p_errnum := 0;