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

Line 588: MSC_DEMANDS D

584: -- rajjain end 07/19/2002
585: p_demand_class,
586: p_level_id),0)) SD_QTY --4365873
587: FROM -- MSC_CALENDAR_DATES C, -- 2859130
588: MSC_DEMANDS D
589: WHERE D.PLAN_ID = p_plan_id
590: AND D.SR_INSTANCE_ID = p_instance_id
591: AND D.INVENTORY_ITEM_ID = p_item_id
592: AND D.ORGANIZATION_ID = p_org_id

Line 985: MSC_DEMANDS D

981: -- rajjain end 07/19/2002
982: p_demand_class,
983: p_level_id),0)) SD_QTY --4365873
984: FROM MSC_CALENDAR_DATES C,
985: MSC_DEMANDS D
986: WHERE D.PLAN_ID = p_plan_id
987: AND D.SR_INSTANCE_ID = p_instance_id
988: AND D.INVENTORY_ITEM_ID = p_item_id
989: AND D.ORGANIZATION_ID = p_org_id

Line 1532: FROM MSC_DEMANDS D

1528: )),
1529: -- rajjain end 07/19/2002
1530: p_demand_class,
1531: p_level_id),0)) SD_QTY --4365873
1532: FROM MSC_DEMANDS D
1533: WHERE D.PLAN_ID = p_plan_id
1534: AND D.SR_INSTANCE_ID = p_instance_id
1535: AND D.INVENTORY_ITEM_ID = p_item_id
1536: AND D.ORGANIZATION_ID = p_org_id

Line 1932: MSC_DEMANDS D

1928: -- rajjain end 07/19/2002
1929: p_demand_class,
1930: p_level_id),0)) SD_QTY --4365873
1931: FROM MSC_CALENDAR_DATES C,
1932: MSC_DEMANDS D
1933: WHERE D.PLAN_ID = p_plan_id
1934: AND D.SR_INSTANCE_ID = p_instance_id
1935: AND D.INVENTORY_ITEM_ID = p_item_id
1936: AND D.ORGANIZATION_ID = p_org_id

Line 2561: MSC_DEMANDS D,

2557: D.DEMAND_CLASS, --bug3263368
2558: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2559: D.REQUEST_SHIP_DATE) --bug3263368
2560: FROM -- MSC_CALENDAR_DATES C, --2859130
2561: MSC_DEMANDS D,
2562: MSC_TRADING_PARTNERS MTP,--bug3263368
2563: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2564: WHERE D.PLAN_ID = p_plan_id
2565: AND D.SR_INSTANCE_ID = p_instance_id

Line 3100: MSC_DEMANDS D,

3096: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
3097: D.REQUEST_SHIP_DATE) --bug3263368
3098:
3099: FROM MSC_CALENDAR_DATES C,
3100: MSC_DEMANDS D,
3101: MSC_TRADING_PARTNERS MTP,--bug3263368
3102: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
3103:
3104: WHERE D.PLAN_ID = p_plan_id