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_ATP_DRP dependencies on MSC_DEMANDS

Line 39: FROM MSC_DEMANDS D

35: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),
36: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) SD_DATE,
37: --plan by requestdate,promisedate,scheduledate
38: -1*D.USING_REQUIREMENT_QUANTITY SD_QTY
39: FROM MSC_DEMANDS D
40: WHERE D.PLAN_ID = p_plan_id
41: AND D.SR_INSTANCE_ID = p_instance_id
42: AND D.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id
43: AND D.ORGANIZATION_ID = p_org_id

Line 220: MSC_DEMANDS D,

216: D.DEMAND_CLASS, --bug3263368
217: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
218: D.REQUEST_SHIP_DATE) --bug3263368
219: FROM
220: MSC_DEMANDS D,
221: MSC_TRADING_PARTNERS MTP,--bug3263368
222: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
223: WHERE D.PLAN_ID = p_plan_id
224: AND D.SR_INSTANCE_ID = p_instance_id

Line 417: MSC_DEMANDS D

413: --plan by request date, promise date or schedule date -- 2859130
414: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY
415: FROM MSC_SYSTEM_ITEMS I,
416: MSC_PLAN_ORGANIZATIONS PO,
417: MSC_DEMANDS D
418: WHERE PO.plan_id = p_plan_id
419: AND I.PLAN_ID = PO.PLAN_ID
420: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID
421: AND I.ORGANIZATION_ID = PO.ORGANIZATION_ID

Line 549: MSC_DEMANDS D

545: 0, D.OLD_DEMAND_QUANTITY, -- For summary enhancement
546: -1 * D.USING_REQUIREMENT_QUANTITY) SD_QTY
547: FROM MSC_SYSTEM_ITEMS I,
548: MSC_PLAN_ORGANIZATIONS PO,
549: MSC_DEMANDS D
550: WHERE PO.plan_id = p_plan_id
551: AND I.PLAN_ID = PO.PLAN_ID
552: AND I.SR_INSTANCE_ID = PO.SR_INSTANCE_ID
553: AND I.ORGANIZATION_ID = PO.ORGANIZATION_ID

Line 745: FROM MSC_DEMANDS D,

741: SELECT TRUNC(NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)) SD_DATE,--plan by request,promise,schedule date
742: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies
743: 0, nvl(D.OLD_DEMAND_QUANTITY,0), --4658238 -- For summary enhancement
744: -1 * D.USING_REQUIREMENT_QUANTITY) SD_QTY
745: FROM MSC_DEMANDS D,
746: MSC_PLANS P -- For summary enhancement
747: WHERE D.PLAN_ID = p_plan_id
748: AND D.SR_INSTANCE_ID = p_instance_id
749: AND D.INVENTORY_ITEM_ID = MSC_ATP_PVT.G_ITEM_INFO_REC.dest_inv_item_id