DBA Data[Home] [Help]

APPS.PJI_PMV_BOOKINGS dependencies on PJI_PMV_ORG_DIM_TMP

Line 290: , PJI_PMV_ORG_DIM_TMP HOU

286: FROM
287: PJI_PMV_TIME_DIM_TMP TIME
288: , PJI_PMV_ORGZ_DIM_TMP HORG
289: , PJI_AC_ORGO_F_MV FCT
290: , PJI_PMV_ORG_DIM_TMP HOU
291: WHERE
292: FCT.ORG_ID = HOU.ID
293: AND FCT.ORGANIZATION_ID = HORG.ID
294: AND FCT.TIME_ID = TIME.ID

Line 335: , PJI_PMV_ORG_DIM_TMP HOU

331: FROM
332: PJI_PMV_TIME_DIM_TMP TIME
333: , PJI_PMV_ORGZ_DIM_TMP HORG
334: , PJI_AC_ORGO_F_MV FCT
335: , PJI_PMV_ORG_DIM_TMP HOU
336: WHERE
337: FCT.ORG_ID = HOU.ID
338: AND FCT.ORGANIZATION_ID = HORG.ID
339: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 375: FROM PJI_PMV_ORG_DIM_TMP

371: , 0
372: , 0
373: , 0
374: , 0
375: FROM PJI_PMV_ORG_DIM_TMP
376: WHERE NAME <> '-1'
377: UNION ALL
378: SELECT '-1' ORG_ID
379: , NAME ORGANIZATION_ID

Line 534: , PJI_PMV_ORG_DIM_TMP HOU

530: PJI_PMV_TIME_DIM_TMP TIME
531: , PJI_PMV_ORGZ_DIM_TMP HORG
532: , PJI_PMV_CLS_DIM_TMP CLS
533: , PJI_AC_CLSO_F_MV FCT
534: , PJI_PMV_ORG_DIM_TMP HOU
535: WHERE
536: FCT.PROJECT_ORG_ID = HOU.ID
537: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
538: AND FCT.TIME_ID = TIME.ID

Line 581: , PJI_PMV_ORG_DIM_TMP HOU

577: PJI_PMV_TIME_DIM_TMP TIME
578: , PJI_PMV_ORGZ_DIM_TMP HORG
579: , PJI_PMV_CLS_DIM_TMP CLS
580: , PJI_AC_CLSO_F_MV FCT
581: , PJI_PMV_ORG_DIM_TMP HOU
582: WHERE
583: FCT.PROJECT_ORG_ID = HOU.ID
584: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
585: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 622: FROM PJI_PMV_ORG_DIM_TMP

618: , 0
619: , 0
620: , 0
621: , 0
622: FROM PJI_PMV_ORG_DIM_TMP
623: WHERE NAME <> '-1'
624: UNION ALL
625: SELECT '-1' ORG_ID
626: , NAME ORGANIZATION_ID