APPS.MST_CMP_KPIS dependencies on MST_PLANS

Line 36: FROM mst_plans

32: WHERE user_Id = -9999;
33:
34: CURSOR cur_plan_info(p_plan_id IN NUMBER) IS
35: SELECT PLAN_ID, currency_uom
36: FROM mst_plans
37: WHERE plan_id = p_plan_id;
38:
39: g_rec_plan_info cur_plan_info%ROWTYPE;
40:

Line 89: MST_PLANS P

85: NVL(T1.TOTAL_ACCESSORIAL_COST, 0) ) TotalCost
86: FROM MST_TRIPS T1
87: WHERE T1.PLAN_ID = p_plan_Id
88: GROUP BY T1.PLAN_ID) T,
89: MST_PLANS P
90: WHERE T.PLAN_ID = P.PLAN_ID;*/
91: -- -----------------------------------------
92: -- As per bug#3535276, We always need to go
93: -- with delivery legs to compute total cost.

Line 109: FROM MST_PLANS P

105: (NVL(P.TOTAL_TL_WEIGHT, 0) +
106: NVL(P.TOTAL_LTL_WEIGHT, 0) +
107: NVL(P.TOTAL_PARCEL_WEIGHT, 0)))
108: AS CostPerUnitWeight
109: FROM MST_PLANS P
110: WHERE P.PLAN_ID = P_PLAN_ID;
111:
112: -- Mode level
113: -- ----------

Line 136: MST_PLANS P

132: FROM MST_TRIPS T1
133: WHERE T1.PLAN_ID = p_plan_id
134: AND T1.MODE_OF_TRANSPORT = g_tload -- 'TRUCK'
135: GROUP BY T1.PLAN_ID ) T,
136: MST_PLANS P
137: WHERE T.PLAN_ID = P.PLAN_ID;
138:
139: -- Mode level - LTL
140: -- -----------------

Line 151: MST_PLANS P

147: FROM MST_TRIPS T1
148: WHERE T1.PLAN_ID = p_plan_id
149: AND T1.MODE_OF_TRANSPORT = g_ltl
150: GROUP BY T1.PLAN_ID ) T,
151: MST_PLANS P
152: WHERE T.PLAN_ID = P.PLAN_ID;
153:
154: -- Mode level - Parcel
155: -- -------------------

Line 166: MST_PLANS P

162: FROM MST_TRIPS T1
163: WHERE T1.PLAN_ID = p_plan_id
164: AND T1.MODE_OF_TRANSPORT = g_parcel
165: GROUP BY T1.PLAN_ID ) T,
166: MST_PLANS P
167: WHERE T.PLAN_ID = P.PLAN_ID;
168:
169: -- Carrier level
170: -- -------------

Line 399: MST_PLANS P

395: FROM MST_TRIPS T1
396: WHERE t1.PLAN_ID = p_plan_id
397: GROUP BY T1.PLAN_ID
398: ) T,
399: MST_PLANS P
400: WHERE T.PLAN_ID = P.PLAN_ID;*/
401: -- -----------------------------------------
402: -- As per bug#3535276, We always need to go
403: -- with delivery legs to compute total cost.

Line 419: FROM MST_PLANS P

415: (NVL(P.TOTAL_TL_VOLUME, 0) +
416: NVL(P.TOTAL_LTL_VOLUME, 0) +
417: NVL(P.TOTAL_PARCEL_VOLUME, 0)))
418: AS CostPerUnitVolume
419: FROM MST_PLANS P
420: WHERE P.PLAN_ID = P_PLAN_ID;
421: -- Mode level - TL
422: -- ---------------
423: -- ---------------------------------------------------

Line 442: MST_PLANS P

438: FROM MST_TRIPS T1
439: WHERE T1.PLAN_ID = p_plan_id
440: AND T1.MODE_OF_TRANSPORT = g_tload
441: GROUP BY T1.PLAN_ID) T,
442: MST_PLANS P
443: WHERE T.PLAN_ID = P.PLAN_ID;
444:
445: -- Mode level - LTL
446: -- -----------------

Line 457: MST_PLANS P

453: FROM MST_TRIPS T1
454: WHERE T1.PLAN_ID = p_plan_id
455: AND T1.MODE_OF_TRANSPORT = g_ltl
456: GROUP BY T1.PLAN_ID) T,
457: MST_PLANS P
458: WHERE T.PLAN_ID = P.PLAN_ID;
459:
460: -- Mode level - Parcel
461: -- -------------------

Line 472: MST_PLANS P

468: FROM MST_TRIPS T1
469: WHERE T1.PLAN_ID = p_plan_id
470: AND T1.MODE_OF_TRANSPORT = g_parcel
471: GROUP BY T1.PLAN_ID) T,
472: MST_PLANS P
473: WHERE T.PLAN_ID = P.PLAN_ID;
474:
475: -- Carrier level
476: -- -------------