eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_AATP_REQ dependencies on MSC_PLANS

Line 165: MSC_PLANS P -- For summary enhancement

161: decode(AD.ALLOCATED_QUANTITY, -- Consider unscheduled orders as dummy supplies
162: 0,NVL(AD.OLD_ALLOCATED_QUANTITY,0), -- For summary enhancement --5283809
163: -1 * AD.ALLOCATED_QUANTITY) SD_QTY
164: FROM MSC_ALLOC_DEMANDS AD,
165: MSC_PLANS P -- For summary enhancement
166: WHERE AD.PLAN_ID = p_plan_id
167: AND AD.SR_INSTANCE_ID = p_instance_id
168: AND AD.INVENTORY_ITEM_ID = l_inv_item_id
169: AND AD.ORGANIZATION_ID = p_organization_id

Line 185: MSC_PLANS P -- For summary enhancement

181: decode(SA.ALLOCATED_QUANTITY, -- Consider deleted stealing records as dummy demands
182: 0, -1 * (NVL(OLD_ALLOCATED_QUANTITY,0)), -- For summary enhancement --5283809
183: SA.ALLOCATED_QUANTITY) SD_QTY
184: FROM MSC_ALLOC_SUPPLIES SA,
185: MSC_PLANS P -- For summary enhancement
186: WHERE SA.PLAN_ID = p_plan_id
187: AND SA.SR_INSTANCE_ID = p_instance_id
188: AND SA.INVENTORY_ITEM_ID = l_inv_item_id
189: AND SA.ORGANIZATION_ID = p_organization_id

Line 1141: FROM msc_plans plans

1137:
1138: -- Summary enhancement changes begin
1139: SELECT summary_flag
1140: INTO l_summary_flag
1141: FROM msc_plans plans
1142: WHERE plans.plan_id = p_plan_id;
1143:
1144: IF PG_DEBUG in ('Y', 'C') THEN
1145: msc_sch_wb.atp_debug('Get_Forward_Material_Atp: ' || 'right before the huge select statement');

Line 1190: MSC_PLANS P -- For summary enhancement

1186: 0, nvl(OLD_ALLOCATED_QUANTITY,0), --4658238 -- For summary enhancement
1187: -1 * AD.ALLOCATED_QUANTITY) SD_QTY,
1188: AD.DEMAND_CLASS
1189: FROM MSC_ALLOC_DEMANDS AD,
1190: MSC_PLANS P -- For summary enhancement
1191: WHERE AD.PLAN_ID = p_plan_id
1192: AND AD.SR_INSTANCE_ID = p_instance_id
1193: AND AD.INVENTORY_ITEM_ID = l_inv_item_id
1194: AND AD.ORGANIZATION_ID = p_organization_id

Line 1213: MSC_PLANS P -- For summary enhancement

1209: 0, -1 * (NVL(OLD_ALLOCATED_QUANTITY,0)), -- For summary enhancement --5283809
1210: SA.ALLOCATED_QUANTITY) SD_QTY ,
1211: SA.DEMAND_CLASS
1212: FROM MSC_ALLOC_SUPPLIES SA,
1213: MSC_PLANS P -- For summary enhancement
1214: WHERE SA.PLAN_ID = p_plan_id
1215: AND SA.SR_INSTANCE_ID = p_instance_id
1216: AND SA.INVENTORY_ITEM_ID = l_inv_item_id
1217: AND SA.ORGANIZATION_ID = p_organization_id