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_WS_SNO_PUBLISH dependencies on MSC_PLANS

Line 201: -- use MSC_PLANS to find owning org and instance

197: raise;
198: END;
199: BEGIN
200: -- CODE GOES HERE Part 2, for Supply category. Need to
201: -- use MSC_PLANS to find owning org and instance
202: INSERT INTO MSC_EXCEPTION_DETAILS (PLAN_ID,
203: SR_INSTANCE_ID,
204: ORGANIZATION_ID,
205: INVENTORY_ITEM_ID,

Line 224: MSC_PLANS.sr_instance_id,

220: CREATION_DATE,
221: CREATED_BY)
222: SELECT
223: MSC_INT_ASCP_EXCEPTION_DETAILS.Plan_Id,
224: MSC_PLANS.sr_instance_id,
225: MSC_PLANS.organization_id,
226: MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID,
227: -1,
228: -1,

Line 225: MSC_PLANS.organization_id,

221: CREATED_BY)
222: SELECT
223: MSC_INT_ASCP_EXCEPTION_DETAILS.Plan_Id,
224: MSC_PLANS.sr_instance_id,
225: MSC_PLANS.organization_id,
226: MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID,
227: -1,
228: -1,
229: MSC_EXCEPTION_DETAILS_S.NEXTVAL,

Line 237: AND msc_supplies.ORGANIZATION_ID=MSC_PLANS.organization_id -- no org id in Supply category

233: TO_DATE(PeriodStart, 'YYYY-MM-DD'),
234: TO_DATE(PeriodEnd, 'YYYY-MM-DD')-1/86400,
235: case when MSC_INT_ASCP_EXCEPTION_DETAILS.AlertCategory = 'Supply'
236: AND msc_supplies.Plan_ID=MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID
237: AND msc_supplies.ORGANIZATION_ID=MSC_PLANS.organization_id -- no org id in Supply category
238: AND msc_supplies.SUPPLIER_SITE_ID =MSC_INT_ASCP_EXCEPTION_DETAILS.Organization_Id
239: AND msc_supplies.SUPPLIER_ID=MSC_INT_ASCP_EXCEPTION_DETAILS.DepartmentId
240: AND msc_supplies.SR_INSTANCE_ID=MSC_INT_ASCP_EXCEPTION_DETAILS.Instance_Id
241: AND msc_supplies.INVENTORY_ITEM_ID=MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID

Line 261: FROM msc_supplies, MSC_INT_ASCP_EXCEPTION_DETAILS, MSC_PLANS

257: SYSDATE,
258: '-1',
259: SYSDATE,
260: '-1'
261: FROM msc_supplies, MSC_INT_ASCP_EXCEPTION_DETAILS, MSC_PLANS
262: WHERE MSC_INT_ASCP_EXCEPTION_DETAILS.AlertCategory='Supply'
263: AND MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID=PlanIdVar
264: AND MSC_INT_ASCP_EXCEPTION_DETAILS.plan_id=msc_supplies.Plan_ID
265: AND MSC_INT_ASCP_EXCEPTION_DETAILS.plan_id=MSC_PLANS.PLAN_ID

Line 265: AND MSC_INT_ASCP_EXCEPTION_DETAILS.plan_id=MSC_PLANS.PLAN_ID

261: FROM msc_supplies, MSC_INT_ASCP_EXCEPTION_DETAILS, MSC_PLANS
262: WHERE MSC_INT_ASCP_EXCEPTION_DETAILS.AlertCategory='Supply'
263: AND MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID=PlanIdVar
264: AND MSC_INT_ASCP_EXCEPTION_DETAILS.plan_id=msc_supplies.Plan_ID
265: AND MSC_INT_ASCP_EXCEPTION_DETAILS.plan_id=MSC_PLANS.PLAN_ID
266: AND msc_supplies.organization_id = MSC_PLANS.organization_id -- use owning org id to suppress extra records
267: AND msc_supplies.SUPPLIER_SITE_ID =MSC_INT_ASCP_EXCEPTION_DETAILS.Organization_Id
268: AND msc_supplies.SUPPLIER_ID=MSC_INT_ASCP_EXCEPTION_DETAILS.DepartmentId
269: AND msc_supplies.SR_INSTANCE_ID = MSC_INT_ASCP_EXCEPTION_DETAILS.Instance_Id

Line 266: AND msc_supplies.organization_id = MSC_PLANS.organization_id -- use owning org id to suppress extra records

262: WHERE MSC_INT_ASCP_EXCEPTION_DETAILS.AlertCategory='Supply'
263: AND MSC_INT_ASCP_EXCEPTION_DETAILS.PLAN_ID=PlanIdVar
264: AND MSC_INT_ASCP_EXCEPTION_DETAILS.plan_id=msc_supplies.Plan_ID
265: AND MSC_INT_ASCP_EXCEPTION_DETAILS.plan_id=MSC_PLANS.PLAN_ID
266: AND msc_supplies.organization_id = MSC_PLANS.organization_id -- use owning org id to suppress extra records
267: AND msc_supplies.SUPPLIER_SITE_ID =MSC_INT_ASCP_EXCEPTION_DETAILS.Organization_Id
268: AND msc_supplies.SUPPLIER_ID=MSC_INT_ASCP_EXCEPTION_DETAILS.DepartmentId
269: AND msc_supplies.SR_INSTANCE_ID = MSC_INT_ASCP_EXCEPTION_DETAILS.Instance_Id
270: AND msc_supplies.INVENTORY_ITEM_ID=MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID

Line 825: SELECT PlanIdVar, MSC_PLANS.ORGANIZATION_ID, MSC_PLANS.SR_INSTANCE_ID,

821: LAST_UPDATE_DATE,
822: LAST_UPDATED_BY,
823: CREATION_DATE,
824: CREATED_BY)
825: SELECT PlanIdVar, MSC_PLANS.ORGANIZATION_ID, MSC_PLANS.SR_INSTANCE_ID,
826: TO_NUMBER(BucketIndex), 1,
827: TO_DATE(BktStartDate,'YYYY-MM-DD'), TO_DATE(BktEndDate,'YYYY-MM-DD')-1/86400,
828: TO_NUMBER(DaysInBucket), TO_NUMBER(BucketType),
829: SYSDATE, '-1',

Line 831: FROM MSC_INT_ASCP_EXPORT_BUCKETS, MSC_PLANS

827: TO_DATE(BktStartDate,'YYYY-MM-DD'), TO_DATE(BktEndDate,'YYYY-MM-DD')-1/86400,
828: TO_NUMBER(DaysInBucket), TO_NUMBER(BucketType),
829: SYSDATE, '-1',
830: SYSDATE, '-1'
831: FROM MSC_INT_ASCP_EXPORT_BUCKETS, MSC_PLANS
832: WHERE PLANID=PlanIdVar AND
833: MSC_PLANS.PLAN_ID=PlanIdVar;
834: EXCEPTION WHEN others THEN
835: g_ErrorCode := 'ERROR_UPDATE_PLAN_BUCKETS_001001';

Line 833: MSC_PLANS.PLAN_ID=PlanIdVar;

829: SYSDATE, '-1',
830: SYSDATE, '-1'
831: FROM MSC_INT_ASCP_EXPORT_BUCKETS, MSC_PLANS
832: WHERE PLANID=PlanIdVar AND
833: MSC_PLANS.PLAN_ID=PlanIdVar;
834: EXCEPTION WHEN others THEN
835: g_ErrorCode := 'ERROR_UPDATE_PLAN_BUCKETS_001001';
836: raise;
837: END;

Line 2237: FROM MSC_PLANS

2233:
2234: BEGIN
2235: BEGIN
2236: SELECT COMPILE_DESIGNATOR INTO l_PlanName
2237: FROM MSC_PLANS
2238: WHERE PLAN_ID = PlanId;
2239: EXCEPTION WHEN NO_DATA_FOUND THEN
2240: Status := 'INVALID_PLANID';
2241: RETURN FALSE;