DBA Data[Home] [Help]

APPS.PJI_AUDIT_RPT dependencies on PJI_RM_RES_WT_F

Line 474: select /*+ index_ffs(rmr, PJI_RM_RES_WT_F_N1)

470: distinct
471: org.ORGANIZATION_ID
472: from
473: (
474: select /*+ index_ffs(rmr, PJI_RM_RES_WT_F_N1)
475: parallel_index(rmr, PJI_RM_RES_WT_F_N1) */
476: rmr.EXPENDITURE_ORGANIZATION_ID ORGANIZATION_ID
477: from
478: PJI_RM_RES_WT_F rmr

Line 475: parallel_index(rmr, PJI_RM_RES_WT_F_N1) */

471: org.ORGANIZATION_ID
472: from
473: (
474: select /*+ index_ffs(rmr, PJI_RM_RES_WT_F_N1)
475: parallel_index(rmr, PJI_RM_RES_WT_F_N1) */
476: rmr.EXPENDITURE_ORGANIZATION_ID ORGANIZATION_ID
477: from
478: PJI_RM_RES_WT_F rmr
479: where

Line 478: PJI_RM_RES_WT_F rmr

474: select /*+ index_ffs(rmr, PJI_RM_RES_WT_F_N1)
475: parallel_index(rmr, PJI_RM_RES_WT_F_N1) */
476: rmr.EXPENDITURE_ORGANIZATION_ID ORGANIZATION_ID
477: from
478: PJI_RM_RES_WT_F rmr
479: where
480: p_params_util_flag = 'Y'
481: union all
482: select /*+ index_ffs(fpp, PJI_FP_PROJ_F_N1)