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 525: MSC_DEMANDS D

521: -- rajjain end 07/19/2002
522: p_demand_class,
523: p_level_id),0)) SD_QTY --4365873
524: FROM -- MSC_CALENDAR_DATES C, -- 2859130
525: MSC_DEMANDS D
526: WHERE D.PLAN_ID = p_plan_id
527: AND D.SR_INSTANCE_ID = p_instance_id
528: AND D.INVENTORY_ITEM_ID = p_item_id
529: AND D.ORGANIZATION_ID = p_org_id

Line 896: MSC_DEMANDS D

892: -- rajjain end 07/19/2002
893: p_demand_class,
894: p_level_id),0)) SD_QTY --4365873
895: FROM MSC_CALENDAR_DATES C,
896: MSC_DEMANDS D
897: WHERE D.PLAN_ID = p_plan_id
898: AND D.SR_INSTANCE_ID = p_instance_id
899: AND D.INVENTORY_ITEM_ID = p_item_id
900: AND D.ORGANIZATION_ID = p_org_id

Line 1401: FROM MSC_DEMANDS D

1397: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))),p_level_id, NULL)))),
1398: -- rajjain end 07/19/2002
1399: p_demand_class,
1400: p_level_id),0)) SD_QTY --4365873
1401: FROM MSC_DEMANDS D
1402: WHERE D.PLAN_ID = p_plan_id
1403: AND D.SR_INSTANCE_ID = p_instance_id
1404: AND D.INVENTORY_ITEM_ID = p_item_id
1405: AND D.ORGANIZATION_ID = p_org_id

Line 1776: MSC_DEMANDS D

1772: -- rajjain end 07/19/2002
1773: p_demand_class,
1774: p_level_id),0)) SD_QTY --4365873
1775: FROM MSC_CALENDAR_DATES C,
1776: MSC_DEMANDS D
1777: WHERE D.PLAN_ID = p_plan_id
1778: AND D.SR_INSTANCE_ID = p_instance_id
1779: AND D.INVENTORY_ITEM_ID = p_item_id
1780: AND D.ORGANIZATION_ID = p_org_id

Line 2363: MSC_DEMANDS D,

2359: D.DEMAND_CLASS, --bug3263368
2360: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2361: D.REQUEST_SHIP_DATE) --bug3263368
2362: FROM -- MSC_CALENDAR_DATES C, --2859130
2363: MSC_DEMANDS D,
2364: MSC_TRADING_PARTNERS MTP,--bug3263368
2365: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2366: WHERE D.PLAN_ID = p_plan_id
2367: AND D.SR_INSTANCE_ID = p_instance_id

Line 2876: MSC_DEMANDS D,

2872: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2873: D.REQUEST_SHIP_DATE) --bug3263368
2874:
2875: FROM MSC_CALENDAR_DATES C,
2876: MSC_DEMANDS D,
2877: MSC_TRADING_PARTNERS MTP,--bug3263368
2878: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2879:
2880: WHERE D.PLAN_ID = p_plan_id