APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PJI_ROWID_ORG_DENORM

Line 391: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_ROWID_ORG_DENORM' , l_low_rows, l_low_blocks, 75);

387: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_AGGR_RES3' , l_high_rows, l_high_blocks, 225);
388: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_RM_ORG_BATCH_MAP' , l_low_rows, l_low_blocks, 75);
389:
390: -- global temporary tables
391: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_ROWID_ORG_DENORM' , l_low_rows, l_low_blocks, 75);
392:
393: -- gather statistics for PJI metadata tables
394: FND_STATS.GATHER_TABLE_STATS(
395: ownname => l_schema

Line 799: insert into PJI_ROWID_ORG_DENORM

795: select ORG_STRUCTURE_VERSION_ID
796: into l_org_structure_version_id
797: from PJI_SYSTEM_SETTINGS;
798:
799: insert into PJI_ROWID_ORG_DENORM
800: (
801: HRI_ROWID,
802: PJI_ROWID,
803: CHANGE_FLAG

Line 827: select /*+ index(org_r, PJI_ROWID_ORG_DENORM_N1) */

823: from PJI_ORG_DENORM denorm
824: where
825: denorm.ROWID not in
826: (
827: select /*+ index(org_r, PJI_ROWID_ORG_DENORM_N1) */
828: org_r.PJI_ROWID
829: from
830: PJI_ROWID_ORG_DENORM org_r
831: where

Line 830: PJI_ROWID_ORG_DENORM org_r

826: (
827: select /*+ index(org_r, PJI_ROWID_ORG_DENORM_N1) */
828: org_r.PJI_ROWID
829: from
830: PJI_ROWID_ORG_DENORM org_r
831: where
832: org_r.PJI_ROWID is not null
833: );
834:

Line 844: select /*+ ordered index(org_r, PJI_ROWID_ORG_DENORM_N1) rowid(hri) */

840: ORGANIZATION_LEVEL,
841: SUB_ORGANIZATION_LEVEL
842: ) =
843: (
844: select /*+ ordered index(org_r, PJI_ROWID_ORG_DENORM_N1) rowid(hri) */
845: hri.ORGANIZATION_LEVEL,
846: hri.SUB_ORGANIZATION_LEVEL
847: from
848: PJI_ROWID_ORG_DENORM org_r,

Line 848: PJI_ROWID_ORG_DENORM org_r,

844: select /*+ ordered index(org_r, PJI_ROWID_ORG_DENORM_N1) rowid(hri) */
845: hri.ORGANIZATION_LEVEL,
846: hri.SUB_ORGANIZATION_LEVEL
847: from
848: PJI_ROWID_ORG_DENORM org_r,
849: HRI_ORG_HRCHY_SUMMARY hri
850: where
851: org_r.PJI_ROWID = denorm.ROWID and
852: hri.ROWID = org_r.HRI_ROWID

Line 857: select /*+ index(org_r, PJI_ROWID_ORG_DENORM_N1) */

853: )
854: where
855: denorm.ROWID in
856: (
857: select /*+ index(org_r, PJI_ROWID_ORG_DENORM_N1) */
858: org_r.PJI_ROWID
859: from
860: PJI_ROWID_ORG_DENORM org_r
861: where

Line 860: PJI_ROWID_ORG_DENORM org_r

856: (
857: select /*+ index(org_r, PJI_ROWID_ORG_DENORM_N1) */
858: org_r.PJI_ROWID
859: from
860: PJI_ROWID_ORG_DENORM org_r
861: where
862: org_r.PJI_ROWID is not null and
863: org_r.CHANGE_FLAG = 'Y'
864: );

Line 885: select /*+ index(org_r, PJI_ROWID_ORG_DENORM_N1) */

881: HRI_ORG_HRCHY_SUMMARY hri
882: where
883: hri.ROWID in
884: (
885: select /*+ index(org_r, PJI_ROWID_ORG_DENORM_N1) */
886: org_r.HRI_ROWID
887: from
888: PJI_ROWID_ORG_DENORM org_r
889: where

Line 888: PJI_ROWID_ORG_DENORM org_r

884: (
885: select /*+ index(org_r, PJI_ROWID_ORG_DENORM_N1) */
886: org_r.HRI_ROWID
887: from
888: PJI_ROWID_ORG_DENORM org_r
889: where
890: org_r.PJI_ROWID is null
891: );
892:

Line 896: || '.PJI_ROWID_ORG_DENORM drop storage';

892:
893: pji_utils.write2log(sql%rowcount || ' rows inserted.');
894:
895: execute immediate 'truncate table '|| pji_utils.get_pji_schema_name
896: || '.PJI_ROWID_ORG_DENORM drop storage';
897:
898: commit;
899:
900: end UPDATE_PJI_ORG_HRCHY;