DBA Data[Home] [Help]

APPS.PJI_PMV_COST dependencies on PJI_PMV_TCMP_DIM_TMP

Line 467: PJI_PMV_TCMP_DIM_TMP TIME

463: , DECODE(TIME.amount_type,1,
464: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
465: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
466: FROM
467: PJI_PMV_TCMP_DIM_TMP TIME
468: , PJI_PMV_ORGZ_DIM_TMP HORG
469: , PJI_FP_ORGO_F_MV fct
470: , PJI_PMV_ORG_DIM_TMP HOU
471: WHERE

Line 614: PJI_PMV_TCMP_DIM_TMP TIME

610: , DECODE(TIME.amount_type,1,
611: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
612: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
613: FROM
614: PJI_PMV_TCMP_DIM_TMP TIME
615: , PJI_PMV_ORGZ_DIM_TMP HORG
616: , PJI_PMV_CLS_DIM_TMP CLS
617: , PJI_FP_CLSO_F_MV FCT
618: , PJI_PMV_ORG_DIM_TMP HOU

Line 782: PJI_PMV_TCMP_DIM_TMP TIME

778: , DECODE(TIME.amount_type,1,
779: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
780: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
781: FROM
782: PJI_PMV_TCMP_DIM_TMP TIME
783: , PJI_PMV_ORGZ_DIM_TMP HORG
784: , PJI_PMV_ET_RT_DIM_TMP ET
785: , PJI_FP_ORGO_ET_F_MV FCT
786: , PJI_PMV_ORG_DIM_TMP HOU

Line 950: PJI_PMV_TCMP_DIM_TMP TIME

946: , DECODE(TIME.amount_type,1,
947: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
948: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
949: FROM
950: PJI_PMV_TCMP_DIM_TMP TIME
951: , PJI_PMV_ORGZ_DIM_TMP HORG
952: , PJI_PMV_WT_DIM_TMP WT
953: , PJI_FP_ORGO_ET_WT_F_MV FCT
954: , PJI_PMV_ORG_DIM_TMP HOU

Line 1121: PJI_PMV_TCMP_DIM_TMP TIME

1117: , DECODE(TIME.amount_type,1,
1118: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1119: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
1120: FROM
1121: PJI_PMV_TCMP_DIM_TMP TIME
1122: , PJI_PMV_ORGZ_DIM_TMP HORG
1123: , PJI_PMV_ET_RT_DIM_TMP ET
1124: , PJI_FP_CLSO_ET_F_MV FCT
1125: , PJI_PMV_CLS_DIM_TMP CLS

Line 1308: PJI_PMV_TCMP_DIM_TMP TIME

1304: , DECODE(TIME.amount_type,1,
1305: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1306: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
1307: FROM
1308: PJI_PMV_TCMP_DIM_TMP TIME
1309: , PJI_PMV_ORGZ_DIM_TMP HORG
1310: , PJI_PMV_ET_RT_DIM_TMP ET
1311: , PJI_FP_ORGO_ET_WT_F_MV FCT
1312: , PJI_PMV_WT_DIM_TMP WT

Line 1492: PJI_PMV_TCMP_DIM_TMP TIME

1488: , DECODE(TIME.amount_type,1,
1489: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1490: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
1491: FROM
1492: PJI_PMV_TCMP_DIM_TMP TIME
1493: , PJI_PMV_ORGZ_DIM_TMP HORG
1494: , PJI_PMV_CLS_DIM_TMP CLS
1495: , PJI_FP_CLSO_ET_WT_F_MV FCT
1496: , PJI_PMV_WT_DIM_TMP WT

Line 1675: PJI_PMV_TCMP_DIM_TMP TIME

1671: , DECODE(TIME.amount_type,1,
1672: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1673: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
1674: FROM
1675: PJI_PMV_TCMP_DIM_TMP TIME
1676: , PJI_PMV_ORGZ_DIM_TMP HORG
1677: , PJI_PMV_ET_RT_DIM_TMP ET
1678: , PJI_FP_CLSO_ET_WT_F_MV FCT
1679: , PJI_PMV_CLS_DIM_TMP CLS