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.

[Home] [Help]

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 221: MSC_DEMANDS D,

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

Line 418: MSC_DEMANDS D

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

Line 550: MSC_DEMANDS D

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

Line 746: FROM MSC_DEMANDS D,

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