DBA Data[Home] [Help]

APPS.PJI_AUDIT_RPT dependencies on PJI_ORG_DENORM

Line 502: select /*+ index_ffs(denorm, PJI_ORG_DENORM_N1)

498: acp.CALENDAR_TYPE = 'C'
499: )org
500: ) org,
501: (
502: select /*+ index_ffs(denorm, PJI_ORG_DENORM_N1)
503: parallel_index(denorm, PJI_ORG_DENORM_N1) */
504: distinct
505: denorm.ORGANIZATION_ID
506: from

Line 503: parallel_index(denorm, PJI_ORG_DENORM_N1) */

499: )org
500: ) org,
501: (
502: select /*+ index_ffs(denorm, PJI_ORG_DENORM_N1)
503: parallel_index(denorm, PJI_ORG_DENORM_N1) */
504: distinct
505: denorm.ORGANIZATION_ID
506: from
507: PJI_ORG_DENORM denorm

Line 507: PJI_ORG_DENORM denorm

503: parallel_index(denorm, PJI_ORG_DENORM_N1) */
504: distinct
505: denorm.ORGANIZATION_ID
506: from
507: PJI_ORG_DENORM denorm
508: where
509: (p_params_cost_flag = 'Y' or
510: p_params_profit_flag = 'Y' or
511: p_params_util_flag = 'Y')