APPS.PJI_FM_SUM_PSI dependencies on PA_RESOURCE_CLASSES_B

Line 35: from PA_RESOURCE_CLASSES_B cls

31: RESOURCE_CLASS_ID
32: )
33: select 'OT' EXP_TYPE_CLASS, -- actuals lookups
34: cls.RESOURCE_CLASS_ID
35: from PA_RESOURCE_CLASSES_B cls
36: where cls.RESOURCE_CLASS_CODE = 'PEOPLE'
37: union all
38: select 'ER' EXP_TYPE_CLASS,
39: cls.RESOURCE_CLASS_ID

Line 40: from PA_RESOURCE_CLASSES_B cls

36: where cls.RESOURCE_CLASS_CODE = 'PEOPLE'
37: union all
38: select 'ER' EXP_TYPE_CLASS,
39: cls.RESOURCE_CLASS_ID
40: from PA_RESOURCE_CLASSES_B cls
41: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
42: union all
43: select 'ST' EXP_TYPE_CLASS,
44: cls.RESOURCE_CLASS_ID

Line 45: from PA_RESOURCE_CLASSES_B cls

41: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
42: union all
43: select 'ST' EXP_TYPE_CLASS,
44: cls.RESOURCE_CLASS_ID
45: from PA_RESOURCE_CLASSES_B cls
46: where cls.RESOURCE_CLASS_CODE = 'PEOPLE'
47: union all
48: select 'INV' EXP_TYPE_CLASS,
49: cls.RESOURCE_CLASS_ID

Line 50: from PA_RESOURCE_CLASSES_B cls

46: where cls.RESOURCE_CLASS_CODE = 'PEOPLE'
47: union all
48: select 'INV' EXP_TYPE_CLASS,
49: cls.RESOURCE_CLASS_ID
50: from PA_RESOURCE_CLASSES_B cls
51: where cls.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
52: union all
53: select 'VI$FINANCIAL' EXP_TYPE_CLASS,
54: cls.RESOURCE_CLASS_ID

Line 55: from PA_RESOURCE_CLASSES_B cls

51: where cls.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
52: union all
53: select 'VI$FINANCIAL' EXP_TYPE_CLASS,
54: cls.RESOURCE_CLASS_ID
55: from PA_RESOURCE_CLASSES_B cls
56: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
57: union all
58: select 'VI$MATERIAL' EXP_TYPE_CLASS,
59: cls.RESOURCE_CLASS_ID

Line 60: from PA_RESOURCE_CLASSES_B cls

56: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
57: union all
58: select 'VI$MATERIAL' EXP_TYPE_CLASS,
59: cls.RESOURCE_CLASS_ID
60: from PA_RESOURCE_CLASSES_B cls
61: where cls.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
62: union all
63: select 'VI$PEOPLE' EXP_TYPE_CLASS,
64: cls.RESOURCE_CLASS_ID

Line 65: from PA_RESOURCE_CLASSES_B cls

61: where cls.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
62: union all
63: select 'VI$PEOPLE' EXP_TYPE_CLASS,
64: cls.RESOURCE_CLASS_ID
65: from PA_RESOURCE_CLASSES_B cls
66: where cls.RESOURCE_CLASS_CODE = 'PEOPLE'
67: union all
68: select 'PJ' EXP_TYPE_CLASS,
69: cls.RESOURCE_CLASS_ID

Line 70: from PA_RESOURCE_CLASSES_B cls

66: where cls.RESOURCE_CLASS_CODE = 'PEOPLE'
67: union all
68: select 'PJ' EXP_TYPE_CLASS,
69: cls.RESOURCE_CLASS_ID
70: from PA_RESOURCE_CLASSES_B cls
71: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
72: union all
73: select 'BTC' EXP_TYPE_CLASS,
74: cls.RESOURCE_CLASS_ID

Line 75: from PA_RESOURCE_CLASSES_B cls

71: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
72: union all
73: select 'BTC' EXP_TYPE_CLASS,
74: cls.RESOURCE_CLASS_ID
75: from PA_RESOURCE_CLASSES_B cls
76: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
77: union all
78: select 'WIP$EQUIPMENT' EXP_TYPE_CLASS,
79: cls.RESOURCE_CLASS_ID

Line 80: from PA_RESOURCE_CLASSES_B cls

76: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
77: union all
78: select 'WIP$EQUIPMENT' EXP_TYPE_CLASS,
79: cls.RESOURCE_CLASS_ID
80: from PA_RESOURCE_CLASSES_B cls
81: where cls.RESOURCE_CLASS_CODE = 'EQUIPMENT'
82: union all
83: select 'WIP$PEOPLE' EXP_TYPE_CLASS,
84: cls.RESOURCE_CLASS_ID

Line 85: from PA_RESOURCE_CLASSES_B cls

81: where cls.RESOURCE_CLASS_CODE = 'EQUIPMENT'
82: union all
83: select 'WIP$PEOPLE' EXP_TYPE_CLASS,
84: cls.RESOURCE_CLASS_ID
85: from PA_RESOURCE_CLASSES_B cls
86: where cls.RESOURCE_CLASS_CODE = 'PEOPLE'
87: union all
88: select 'WIP$OTHER' EXP_TYPE_CLASS,
89: cls.RESOURCE_CLASS_ID

Line 90: from PA_RESOURCE_CLASSES_B cls

86: where cls.RESOURCE_CLASS_CODE = 'PEOPLE'
87: union all
88: select 'WIP$OTHER' EXP_TYPE_CLASS,
89: cls.RESOURCE_CLASS_ID
90: from PA_RESOURCE_CLASSES_B cls
91: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
92: union all
93: select 'USG$Y' EXP_TYPE_CLASS,
94: cls.RESOURCE_CLASS_ID

Line 95: from PA_RESOURCE_CLASSES_B cls

91: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
92: union all
93: select 'USG$Y' EXP_TYPE_CLASS,
94: cls.RESOURCE_CLASS_ID
95: from PA_RESOURCE_CLASSES_B cls
96: where cls.RESOURCE_CLASS_CODE = 'EQUIPMENT'
97: union all
98: select 'USG$N' EXP_TYPE_CLASS,
99: cls.RESOURCE_CLASS_ID

Line 100: from PA_RESOURCE_CLASSES_B cls

96: where cls.RESOURCE_CLASS_CODE = 'EQUIPMENT'
97: union all
98: select 'USG$N' EXP_TYPE_CLASS,
99: cls.RESOURCE_CLASS_ID
100: from PA_RESOURCE_CLASSES_B cls
101: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
102: union all
103: select 'PJI$NULL' EXP_TYPE_CLASS,
104: cls.RESOURCE_CLASS_ID

Line 105: from PA_RESOURCE_CLASSES_B cls

101: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
102: union all
103: select 'PJI$NULL' EXP_TYPE_CLASS,
104: cls.RESOURCE_CLASS_ID
105: from PA_RESOURCE_CLASSES_B cls
106: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
107: union all
108: select cls.RESOURCE_CLASS_CODE EXP_TYPE_CLASS, -- commitments lookups
109: cls.RESOURCE_CLASS_ID

Line 110: from PA_RESOURCE_CLASSES_B cls

106: where cls.RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS'
107: union all
108: select cls.RESOURCE_CLASS_CODE EXP_TYPE_CLASS, -- commitments lookups
109: cls.RESOURCE_CLASS_ID
110: from PA_RESOURCE_CLASSES_B cls
111: where cls.RESOURCE_CLASS_CODE in ('FINANCIAL_ELEMENTS',
112: 'MATERIAL_ITEMS',
113: 'EQUIPMENT',
114: 'PEOPLE');

Line 1346: PA_RESOURCE_CLASSES_B classes,

1342: cat.CATEGORY_ID ITEM_CATEGORY_ID,
1343: cat.INVENTORY_ITEM_ID,
1344: cat.ORGANIZATION_ID
1345: from
1346: PA_RESOURCE_CLASSES_B classes,
1347: PA_PLAN_RES_DEFAULTS cls,
1348: MTL_ITEM_CATEGORIES cat -- (+) big
1349: where
1350: classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS' and