DBA Data[Home] [Help]

APPS.PJI_PMV_BOOKINGS dependencies on PJI_PMV_ORGZ_DIM_TMP

Line 288: , PJI_PMV_ORGZ_DIM_TMP HORG

284: , 0
285: , 0
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

Line 333: , PJI_PMV_ORGZ_DIM_TMP HORG

329: , 0
330: , 0
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

Line 408: FROM PJI_PMV_ORGZ_DIM_TMP

404: , 0
405: , 0
406: , 0
407: , 0
408: FROM PJI_PMV_ORGZ_DIM_TMP
409: WHERE NAME <> '-1'
410: UNION ALL
411: SELECT '-1' ORG_ID
412: , '-1' ORGANIZATION_ID

Line 531: , PJI_PMV_ORGZ_DIM_TMP HORG

527: , 0
528: , 0
529: FROM
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

Line 578: , PJI_PMV_ORGZ_DIM_TMP HORG

574: , 0
575: , 0
576: FROM
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

Line 655: FROM PJI_PMV_ORGZ_DIM_TMP

651: , 0
652: , 0
653: , 0
654: , 0
655: FROM PJI_PMV_ORGZ_DIM_TMP
656: WHERE NAME <> '-1'
657: UNION ALL
658: SELECT '-1' ORG_ID
659: , '-1' ORGANIZATION_ID