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.PJI_PJP_GEN_PERF_ALL dependencies on PJI_TIME_CAL_PERIOD

Line 155: index (pji_time PJI_TIME_CAL_PERIOD_U2)*/

151: , PRG_LEVEL
152: , PLAN_TYPE_CODE
153: )
154: SELECT /*+ ordered no_merge(plr)
155: index (pji_time PJI_TIME_CAL_PERIOD_U2)*/
156: g_worker_id WORKER_ID
157: , plr.PROJECT_ID
158: , plr.PROJECT_ORG_ID
159: , plr.project_ORGANIZATION_ID

Line 163: , pji_time.cal_period_id) time_id

159: , plr.project_ORGANIZATION_ID
160: , plr.WBS_ELEMENT_ID project_element_id
161: , DECODE(plr.time_phased_type_code
162: , 'N', -1
163: , pji_time.cal_period_id) time_id
164: , DECODE(plr.time_phased_type_code
165: , 'P', 32
166: , 'G', 32
167: , 'N', 2048

Line 544: , pji_time_cal_period pji_time

540: , collapse_bl.time_phased_type_code
541: ) plr
542: ---- End of first inline view plr ..........
543: , PJI_ORG_EXTR_INFO orginfo
544: , pji_time_cal_period pji_time
545: WHERE 1=1
546: -- AND orginfo.projfunc_currency_mau is not NULL
547: AND plr.project_org_id = orginfo.org_id
548: AND DECODE(plr.time_phased_type_code

Line 560: , pji_time.cal_period_id)

556: , plr.project_ORGANIZATION_ID
557: , plr.WBS_ELEMENT_ID
558: , DECODE(plr.time_phased_type_code
559: , 'N', -1
560: , pji_time.cal_period_id)
561: , DECODE(plr.time_phased_type_code
562: , 'P', 32
563: , 'G', 32
564: , 'N', 2048

Line 874: , pji_time.cal_period_id) time_id

870: , plr.project_ORGANIZATION_ID
871: , plr.WBS_ELEMENT_ID
872: , DECODE(plr.time_phased_type_code
873: , 'N', -1
874: , pji_time.cal_period_id) time_id
875: , DECODE(plr.time_phased_type_code
876: , 'P', 32
877: , 'G', 32
878: , 'N', 2048

Line 1170: , pji_time_cal_period_v pji_time

1166: ,collapse_bl.plan_type_code
1167: ) plr
1168: ---- End of first inline view plr ..........
1169: , PJI_ORG_EXTR_INFO orginfo
1170: , pji_time_cal_period_v pji_time
1171: WHERE 1=1
1172: -- AND orginfo.projfunc_currency_mau is not TO_NUMBER(NULL
1173: AND plr.project_org_id = orginfo.org_id
1174: AND DECODE(plr.time_phased_type_code

Line 1186: , pji_time.cal_period_id)

1182: , plr.project_ORGANIZATION_ID
1183: , plr.WBS_ELEMENT_ID
1184: , DECODE(plr.time_phased_type_code
1185: , 'N', -1
1186: , pji_time.cal_period_id)
1187: , DECODE(plr.time_phased_type_code
1188: , 'P', 32
1189: , 'G', 32
1190: , 'N', 2048

Line 1307: , pji_time.cal_period_id) time_id

1303: , plr.project_ORGANIZATION_ID
1304: , plr.WBS_ELEMENT_ID project_element_id
1305: , DECODE(plr.time_phased_type_code
1306: , 'N', -1
1307: , pji_time.cal_period_id) time_id
1308: , DECODE(plr.time_phased_type_code
1309: , 'P', 32
1310: , 'G', 32
1311: , 'N', 2048

Line 1609: , pji_time_cal_period_v pji_time

1605: , collapse_bl.time_phased_type_code
1606: ) plr
1607: ---- End of first inline view plr ..........
1608: , PJI_ORG_EXTR_INFO orginfo
1609: , pji_time_cal_period_v pji_time
1610: WHERE 1=1
1611: -- AND orginfo.projfunc_currency_mau is not NULL
1612: AND plr.project_org_id = orginfo.org_id
1613: AND DECODE(plr.time_phased_type_code

Line 1625: , pji_time.cal_period_id)

1621: , plr.project_ORGANIZATION_ID
1622: , plr.WBS_ELEMENT_ID
1623: , DECODE(plr.time_phased_type_code
1624: , 'N', -1
1625: , pji_time.cal_period_id)
1626: , DECODE(plr.time_phased_type_code
1627: , 'P', 32
1628: , 'G', 32
1629: , 'N', 2048