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.JTF_RS_DEFAULT_GROUPS_CONC_PUB dependencies on JTF_RS_DEFAULT_GROUPS_S

Line 6: JTF_RS_DEFAULT_GROUPS_STAGE and JTF_RS_DEFAULT_GROUPS. This program will create

2: /* $Header: jtfrsbcb.pls 120.0 2005/05/11 08:19:15 appldev noship $ */
3:
4: /****************************************************************************
5: This is a concurrent program to populate the data in JTF_RS_DEFAULT_GROUPS_INT,
6: JTF_RS_DEFAULT_GROUPS_STAGE and JTF_RS_DEFAULT_GROUPS. This program will create
7: primary groups for resources based on usage and rules (specified by product
8: teams) for date date range from 01/01/1900 to 12/31/4712. For a specific date
9: there will be only one primary group for a resource in JTF_RS_DEFAULT_GROUPS.
10:

Line 15: Introduced new staging table JTF_RS_DEFAULT_GROUPS_STAGE

11: Currently, it is being used for only Field Service Application.
12:
13: CREATED BY nsinghai 20-JUL-2004
14: MODIFIED BY nsinghai 20-SEP-2004 Made JTF_RS_DEFUALT_GROUPS incremental.
15: Introduced new staging table JTF_RS_DEFAULT_GROUPS_STAGE
16: Only Delta Records will be populated in
17: JTF_RS_DEFAULT_GROUPS table.
18: nsinghai 27-SEP-2004 Bug 3917477 : Defaulting to -1 group
19: should be the last consideration. If any other group

Line 209: SELECT JTF_RS_DEFAULT_GROUPS_STAGE_s.NEXTVAL default_groups_id,

205: (default_groups_id, resource_id, user_id, resource_number,
206: group_id, role_type_code, role_id, role_type_priority,
207: role_priority, start_date, end_date, denorm_count, usage,
208: created_by, creation_date, last_updated_by, last_update_date )
209: SELECT JTF_RS_DEFAULT_GROUPS_STAGE_s.NEXTVAL default_groups_id,
210: x.resource_id, x.user_id, x.resource_number,
211: x.group_id,
212: x.role_type_code, x.role_id, x.role_type_priority, x.role_priority,
213: x.start_date, x.end_date, x.denorm_count, 'FLD_SRV_DISTRICT' usage,

Line 280: SELECT JTF_RS_DEFAULT_GROUPS_STAGE_s.NEXTVAL default_groups_id,

276: (default_groups_id, resource_id, user_id, resource_number,
277: group_id, role_type_code, role_id, role_type_priority,
278: role_priority, start_date, end_date, denorm_count, usage,
279: created_by, creation_date, last_updated_by, last_update_date )
280: SELECT JTF_RS_DEFAULT_GROUPS_STAGE_s.NEXTVAL default_groups_id,
281: x.resource_id, x.user_id, x.resource_number,
282: x.group_id,
283: x.role_type_code, x.role_id, x.role_type_priority, x.role_priority,
284: x.start_date, x.end_date, x.denorm_count, 'FLD_SRV_DISTRICT' usage,

Line 332: l_stage := 'Stage=TRUNCATE_JTF_RS_DEFAULT_GROUPS_STAGE_TABLE';

328: percent=>5, degree=>f_get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
329:
330: -------------Truncate the Staging table ---------
331:
332: l_stage := 'Stage=TRUNCATE_JTF_RS_DEFAULT_GROUPS_STAGE_TABLE';
333:
334: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_STAGE';
335:
336: COMMIT;

Line 334: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_STAGE';

330: -------------Truncate the Staging table ---------
331:
332: l_stage := 'Stage=TRUNCATE_JTF_RS_DEFAULT_GROUPS_STAGE_TABLE';
333:
334: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_STAGE';
335:
336: COMMIT;
337:
338: ------------ Start the main logic here --------

Line 557: INSERT INTO /+ APPEND PARALLEL(sg1) NOLOGGING / JTF_RS_DEFAULT_GROUPS_STAGE sg1

553: o := g_default_grp_tab.FIRST ;
554:
555: WHILE o IS NOT NULL
556: LOOP
557: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ JTF_RS_DEFAULT_GROUPS_STAGE sg1
558: (default_groups_id, resource_id, user_id, resource_number,
559: group_id, start_date, end_date, usage,
560: created_by, creation_date, last_updated_by, last_update_date )
561: VALUES (JTF_RS_DEFAULT_GROUPS_STAGE_S.NEXTVAL, g_default_grp_tab(o).p_resource_id,

Line 561: VALUES (JTF_RS_DEFAULT_GROUPS_STAGE_S.NEXTVAL, g_default_grp_tab(o).p_resource_id,

557: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ JTF_RS_DEFAULT_GROUPS_STAGE sg1
558: (default_groups_id, resource_id, user_id, resource_number,
559: group_id, start_date, end_date, usage,
560: created_by, creation_date, last_updated_by, last_update_date )
561: VALUES (JTF_RS_DEFAULT_GROUPS_STAGE_S.NEXTVAL, g_default_grp_tab(o).p_resource_id,
562: g_default_grp_tab(o).p_user_id, g_default_grp_tab(o).p_resource_number,
563: g_default_grp_tab(o).p_group_id, g_default_grp_tab(o).p_start_date,
564: g_default_grp_tab(o).p_end_date, l_usage,
565: l_user_id, sysdate, l_user_id, sysdate);

Line 578: l_stage := 'Stage=ANALYZING_JTF_RS_DEFAULT_GROUPS_STAGE_TABLE';

574:
575: END LOOP; -- end of c_outer cursor
576:
577: -- analyze the Main table
578: l_stage := 'Stage=ANALYZING_JTF_RS_DEFAULT_GROUPS_STAGE_TABLE';
579:
580: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS_STAGE',
581: percent=>5, degree=>f_get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
582:

Line 580: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS_STAGE',

576:
577: -- analyze the Main table
578: l_stage := 'Stage=ANALYZING_JTF_RS_DEFAULT_GROUPS_STAGE_TABLE';
579:
580: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS_STAGE',
581: percent=>5, degree=>f_get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
582:
583: -- Now compare data in recently refreshed table JTF_RS_DEFAULT_GROUPS_STAGE (new) with
584: -- previously populated table JTF_RS_DEFAULT_GROUPS (old) (final incremental table)

Line 583: -- Now compare data in recently refreshed table JTF_RS_DEFAULT_GROUPS_STAGE (new) with

579:
580: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS_STAGE',
581: percent=>5, degree=>f_get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
582:
583: -- Now compare data in recently refreshed table JTF_RS_DEFAULT_GROUPS_STAGE (new) with
584: -- previously populated table JTF_RS_DEFAULT_GROUPS (old) (final incremental table)
585:
586: -- If there is some data in JTF_RS_DEFAULT_GROUPS (old data) which does not exist in
587: -- recently refreshed table JTF_RS_DEFAULT_GROUPS_STAGE, it means it is STALE data and

Line 587: -- recently refreshed table JTF_RS_DEFAULT_GROUPS_STAGE, it means it is STALE data and

583: -- Now compare data in recently refreshed table JTF_RS_DEFAULT_GROUPS_STAGE (new) with
584: -- previously populated table JTF_RS_DEFAULT_GROUPS (old) (final incremental table)
585:
586: -- If there is some data in JTF_RS_DEFAULT_GROUPS (old data) which does not exist in
587: -- recently refreshed table JTF_RS_DEFAULT_GROUPS_STAGE, it means it is STALE data and
588: -- has to be DELETED from JTF_RS_DEFAULT_GROUPS (final table)
589:
590: l_stage := 'Stage=DELETE_DATA_FROM_JTF_RS_DEFAULT_GROUPS_TABLE';
591:

Line 599: FROM jtf_rs_default_groups_stage

595: SELECT resource_id, NVL(user_id,-84), group_id, START_DATE, end_date, usage
596: FROM jtf_rs_default_groups
597: MINUS
598: SELECT resource_id, NVL(user_id,-84), group_id, START_DATE, end_date, usage
599: FROM jtf_rs_default_groups_stage
600: ) ;
601:
602: COMMIT;
603:

Line 604: -- If there is some data in recently refreshed table JTF_RS_DEFAULT_GROUPS_STAGE

600: ) ;
601:
602: COMMIT;
603:
604: -- If there is some data in recently refreshed table JTF_RS_DEFAULT_GROUPS_STAGE
605: -- (new data) which does not exist in final table JTF_RS_DEFAULT_GROUPS_STAGE, it
606: -- means it is NEW data and has to be INSERTED in JTF_RS_DEFAULT_GROUPS (final table)
607:
608: l_stage := 'Stage=INSERT_DATA_IN_JTF_RS_DEFAULT_GROUPS_TABLE';

Line 605: -- (new data) which does not exist in final table JTF_RS_DEFAULT_GROUPS_STAGE, it

601:
602: COMMIT;
603:
604: -- If there is some data in recently refreshed table JTF_RS_DEFAULT_GROUPS_STAGE
605: -- (new data) which does not exist in final table JTF_RS_DEFAULT_GROUPS_STAGE, it
606: -- means it is NEW data and has to be INSERTED in JTF_RS_DEFAULT_GROUPS (final table)
607:
608: l_stage := 'Stage=INSERT_DATA_IN_JTF_RS_DEFAULT_GROUPS_TABLE';
609:

Line 610: INSERT INTO /+ APPEND PARALLEL(sg1) NOLOGGING / jtf_rs_default_groups sg1

606: -- means it is NEW data and has to be INSERTED in JTF_RS_DEFAULT_GROUPS (final table)
607:
608: l_stage := 'Stage=INSERT_DATA_IN_JTF_RS_DEFAULT_GROUPS_TABLE';
609:
610: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ jtf_rs_default_groups sg1
611: (default_groups_id, resource_id, user_id, resource_number,
612: group_id, start_date, end_date, usage,
613: created_by, creation_date, last_updated_by, last_update_date )
614: SELECT

Line 615: jtf_rs_default_groups_s.NEXTVAL, resource_id, user_id, resource_number,

611: (default_groups_id, resource_id, user_id, resource_number,
612: group_id, start_date, end_date, usage,
613: created_by, creation_date, last_updated_by, last_update_date )
614: SELECT
615: jtf_rs_default_groups_s.NEXTVAL, resource_id, user_id, resource_number,
616: group_id, start_date, end_date, usage,
617: l_user_id created_by, SYSDATE creation_date, l_user_id last_updated_by, SYSDATE
618: FROM (
619: SELECT resource_id, user_id, resource_number, group_id, START_DATE, end_date, usage

Line 620: FROM jtf_rs_default_groups_stage

616: group_id, start_date, end_date, usage,
617: l_user_id created_by, SYSDATE creation_date, l_user_id last_updated_by, SYSDATE
618: FROM (
619: SELECT resource_id, user_id, resource_number, group_id, START_DATE, end_date, usage
620: FROM jtf_rs_default_groups_stage
621: MINUS
622: SELECT resource_id, user_id, resource_number, group_id, START_DATE, end_date, usage
623: FROM jtf_rs_default_groups
624: );