DBA Data[Home] [Help]

APPS.PJI_PMV_PROFITABILITY dependencies on PJI_FP_ORGO_ET_WT_F_MV

Line 1435: , PJI_FP_ORGO_ET_WT_F_MV fct

1431: FROM
1432: PJI_PMV_TIME_DIM_TMP TIME
1433: , PJI_PMV_ORGZ_DIM_TMP HORG
1434: , PJI_PMV_WT_DIM_TMP WT
1435: , PJI_FP_ORGO_ET_WT_F_MV fct
1436: , PJI_PMV_ORG_DIM_TMP HOU
1437:
1438: WHERE
1439: FCT.ORG_ID = HOU.ID

Line 1466: , PJI_FP_ORGO_ET_WT_F_MV fct

1462: FROM
1463: PJI_PMV_TIME_DIM_TMP TIME
1464: , PJI_PMV_ORGZ_DIM_TMP HORG
1465: , PJI_PMV_WT_DIM_TMP WT
1466: , PJI_FP_ORGO_ET_WT_F_MV fct
1467: , PJI_PMV_ORG_DIM_TMP HOU
1468: WHERE
1469: FCT.ORG_ID = HOU.ID
1470: AND FCT.ORGANIZATION_ID = HORG.ID

Line 1498: , PJI_FP_ORGO_ET_WT_F_MV fct

1494: FROM
1495: PJI_PMV_TIME_DIM_TMP TIME
1496: , PJI_PMV_ORGZ_DIM_TMP HORG
1497: , PJI_PMV_WT_DIM_TMP WT
1498: , PJI_FP_ORGO_ET_WT_F_MV fct
1499: , PJI_PMV_ORG_DIM_TMP HOU
1500:
1501: WHERE
1502: FCT.ORG_ID = HOU.ID

Line 1531: , PJI_FP_ORGO_ET_WT_F_MV fct

1527: FROM
1528: PJI_PMV_TIME_DIM_TMP TIME
1529: , PJI_PMV_ORGZ_DIM_TMP HORG
1530: , PJI_PMV_WT_DIM_TMP WT
1531: , PJI_FP_ORGO_ET_WT_F_MV fct
1532: , PJI_PMV_ORG_DIM_TMP HOU
1533: WHERE
1534: FCT.ORG_ID = HOU.ID
1535: AND FCT.ORGANIZATION_ID = HORG.ID

Line 1561: , PJI_FP_ORGO_ET_WT_F_MV fct

1557: FROM
1558: PJI_PMV_TIME_DIM_TMP TIME
1559: , PJI_PMV_ORGZ_DIM_TMP HORG
1560: , PJI_PMV_WT_DIM_TMP WT
1561: , PJI_FP_ORGO_ET_WT_F_MV fct
1562: , PJI_PMV_ORG_DIM_TMP HOU
1563: WHERE
1564: FCT.ORG_ID = HOU.ID
1565: AND FCT.ORGANIZATION_ID = HORG.ID

Line 1590: , PJI_FP_ORGO_ET_WT_F_MV fct

1586: , null AS P_CHANGE22
1587: FROM PJI_PMV_TIME_DIM_TMP TIME
1588: , PJI_PMV_ORGZ_DIM_TMP HORG
1589: , PJI_PMV_WT_DIM_TMP WT
1590: , PJI_FP_ORGO_ET_WT_F_MV fct
1591: , PJI_PMV_ORG_DIM_TMP HOU
1592: WHERE
1593: FCT.ORG_ID = HOU.ID
1594: AND FCT.ORGANIZATION_ID = HORG.ID

Line 2001: , PJI_FP_ORGO_ET_WT_F_MV fct

1997: PJI_PMV_TIME_DIM_TMP TIME
1998: , PJI_PMV_ORGZ_DIM_TMP HORG
1999: , PJI_PMV_ET_RT_DIM_TMP ET
2000: , PJI_PMV_WT_DIM_TMP WT
2001: , PJI_FP_ORGO_ET_WT_F_MV fct
2002: , PJI_PMV_ORG_DIM_TMP HOU
2003:
2004: WHERE
2005: FCT.ORG_ID = HOU.ID

Line 2035: , PJI_FP_ORGO_ET_WT_F_MV fct

2031: PJI_PMV_TIME_DIM_TMP TIME
2032: , PJI_PMV_ORGZ_DIM_TMP HORG
2033: , PJI_PMV_ET_RT_DIM_TMP ET
2034: , PJI_PMV_WT_DIM_TMP WT
2035: , PJI_FP_ORGO_ET_WT_F_MV fct
2036: , PJI_PMV_ORG_DIM_TMP HOU
2037: WHERE
2038: FCT.ORG_ID = HOU.ID
2039: AND FCT.ORGANIZATION_ID = HORG.ID

Line 2071: , PJI_FP_ORGO_ET_WT_F_MV fct

2067: PJI_PMV_TIME_DIM_TMP TIME
2068: , PJI_PMV_ORGZ_DIM_TMP HORG
2069: , PJI_PMV_ET_RT_DIM_TMP ET
2070: , PJI_PMV_WT_DIM_TMP WT
2071: , PJI_FP_ORGO_ET_WT_F_MV fct
2072: , PJI_PMV_ORG_DIM_TMP HOU
2073:
2074: WHERE
2075: FCT.ORG_ID = HOU.ID

Line 2107: , PJI_FP_ORGO_ET_WT_F_MV fct

2103: PJI_PMV_TIME_DIM_TMP TIME
2104: , PJI_PMV_ORGZ_DIM_TMP HORG
2105: , PJI_PMV_ET_RT_DIM_TMP ET
2106: , PJI_PMV_WT_DIM_TMP WT
2107: , PJI_FP_ORGO_ET_WT_F_MV fct
2108: , PJI_PMV_ORG_DIM_TMP HOU
2109: WHERE
2110: FCT.ORG_ID = HOU.ID
2111: AND FCT.ORGANIZATION_ID = HORG.ID

Line 2140: , PJI_FP_ORGO_ET_WT_F_MV fct

2136: PJI_PMV_TIME_DIM_TMP TIME
2137: , PJI_PMV_ORGZ_DIM_TMP HORG
2138: , PJI_PMV_ET_RT_DIM_TMP ET
2139: , PJI_PMV_WT_DIM_TMP WT
2140: , PJI_FP_ORGO_ET_WT_F_MV fct
2141: , PJI_PMV_ORG_DIM_TMP HOU
2142: WHERE
2143: FCT.ORG_ID = HOU.ID
2144: AND FCT.ORGANIZATION_ID = HORG.ID

Line 2172: , PJI_FP_ORGO_ET_WT_F_MV fct

2168: FROM PJI_PMV_TIME_DIM_TMP TIME
2169: , PJI_PMV_ORGZ_DIM_TMP HORG
2170: , PJI_PMV_ET_RT_DIM_TMP ET
2171: , PJI_PMV_WT_DIM_TMP WT
2172: , PJI_FP_ORGO_ET_WT_F_MV fct
2173: , PJI_PMV_ORG_DIM_TMP HOU
2174: WHERE
2175: FCT.ORG_ID = HOU.ID
2176: AND FCT.ORGANIZATION_ID = HORG.ID

Line 4757: , PJI_FP_ORGO_ET_WT_F_MV fct

4753: FROM
4754: PJI_PMV_TIME_DIM_TMP TIME
4755: , PJI_PMV_ORGZ_DIM_TMP HORG
4756: , PJI_PMV_WT_DIM_TMP WT
4757: , PJI_FP_ORGO_ET_WT_F_MV fct
4758: , PJI_PMV_ORG_DIM_TMP HOU
4759: WHERE
4760: fct.org_id = hou.id
4761: AND FCT.ORGANIZATION_ID = HORG.ID

Line 4790: , PJI_FP_ORGO_ET_WT_F_MV fct

4786: FROM
4787: PJI_PMV_TIME_DIM_TMP TIME
4788: , PJI_PMV_ORGZ_DIM_TMP HORG
4789: , PJI_PMV_WT_DIM_TMP WT
4790: , PJI_FP_ORGO_ET_WT_F_MV fct
4791: , PJI_PMV_ORG_DIM_TMP HOU
4792: WHERE
4793: fct.org_id = hou.id
4794: AND FCT.ORGANIZATION_ID = HORG.ID

Line 4826: , PJI_FP_ORGO_ET_WT_F_MV fct

4822: FROM
4823: PJI_PMV_TCMP_DIM_TMP TIME
4824: , PJI_PMV_ORGZ_DIM_TMP HORG
4825: , PJI_PMV_WT_DIM_TMP WT
4826: , PJI_FP_ORGO_ET_WT_F_MV fct
4827: , PJI_PMV_ORG_DIM_TMP HOU
4828: WHERE
4829: fct.org_id = hou.id
4830: AND FCT.ORGANIZATION_ID = HORG.ID

Line 5183: , PJI_FP_ORGO_ET_WT_F_MV fct

5179: PJI_PMV_TIME_DIM_TMP TIME
5180: , PJI_PMV_ORGZ_DIM_TMP HORG
5181: , PJI_PMV_ET_RT_DIM_TMP ET
5182: , PJI_PMV_WT_DIM_TMP WT
5183: , PJI_FP_ORGO_ET_WT_F_MV fct
5184: , PJI_PMV_ORG_DIM_TMP HOU
5185: WHERE
5186: fct.org_id = hou.id
5187: AND FCT.ORGANIZATION_ID = HORG.ID

Line 5219: , PJI_FP_ORGO_ET_WT_F_MV fct

5215: PJI_PMV_TIME_DIM_TMP TIME
5216: , PJI_PMV_ORGZ_DIM_TMP HORG
5217: , PJI_PMV_ET_RT_DIM_TMP ET
5218: , PJI_PMV_WT_DIM_TMP WT
5219: , PJI_FP_ORGO_ET_WT_F_MV fct
5220: , PJI_PMV_ORG_DIM_TMP HOU
5221: WHERE
5222: fct.org_id = hou.id
5223: AND FCT.ORGANIZATION_ID = HORG.ID

Line 5258: , PJI_FP_ORGO_ET_WT_F_MV fct

5254: PJI_PMV_TCMP_DIM_TMP TIME
5255: , PJI_PMV_ORGZ_DIM_TMP HORG
5256: , PJI_PMV_ET_RT_DIM_TMP ET
5257: , PJI_PMV_WT_DIM_TMP WT
5258: , PJI_FP_ORGO_ET_WT_F_MV fct
5259: , PJI_PMV_ORG_DIM_TMP HOU
5260: WHERE
5261: fct.org_id = hou.id
5262: AND FCT.ORGANIZATION_ID = HORG.ID