[Home] [Help]
2563: FROM MSC_CALENDAR_DATES C,
2564: MSC_DEMANDS D,
2565: MSC_ATP_RULES R,
2566: MSC_SYSTEM_ITEMS I,
2567: MSC_TRADING_PARTNERS MTP,--bug3263368
2568: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2569: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2570: AND I.ORGANIZATION_ID = p_org_id
2571: AND I.SR_INSTANCE_ID = p_instance_id
2647: MSC_SALES_ORDERS D,
2648: MSC_ATP_RULES R,
2649: MSC_SYSTEM_ITEMS I,
2650: MSC_CALENDAR_DATES C,
2651: MSC_TRADING_PARTNERS MTP,--bug3263368
2652: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2653: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2654: AND I.ORGANIZATION_ID = p_org_id
2655: AND I.SR_INSTANCE_ID = p_instance_id
2961: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2962: D.REQUEST_SHIP_DATE) --bug3263368
2963: FROM MSC_SYSTEM_ITEMS I,
2964: MSC_DEMANDS D,
2965: MSC_TRADING_PARTNERS MTP,--bug3263368
2966: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2967: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2968: AND I.ORGANIZATION_ID = p_org_id
2969: AND I.SR_INSTANCE_ID = p_instance_id
3169: D.REQUEST_SHIP_DATE) --bug3263368
3170: FROM MSC_SYSTEM_ITEMS I,
3171: MSC_DEMANDS D,
3172: MSC_CALENDAR_DATES C,
3173: MSC_TRADING_PARTNERS MTP,--bug3263368
3174: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
3175: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
3176: AND I.ORGANIZATION_ID = p_org_id
3177: AND I.SR_INSTANCE_ID = p_instance_id
9575: mbt.atp_flag
9576: FROM msc_bom_temp mbt,
9577: msc_calendar_dates c2,
9578: msc_calendar_dates c1,
9579: msc_trading_partners tp
9580: WHERE mbt.session_id = MSC_ATP_PVT.G_SESSION_ID
9581: --AND mbt.assembly_identifier = MSC_ATP_PVT.G_ASSEMBLY_LINE_ID
9582: AND mbt.assembly_identifier = MSC_ATP_PVT.G_COMP_LINE_ID
9583: AND mbt.assembly_item_id = l_inventory_item_id
11458: --=======================================================================================================
11459: IF l_calendar_code = '@@@' THEN
11460: SELECT tp.calendar_code
11461: INTO l_calendar_code
11462: FROM msc_trading_partners tp,
11463: msc_plans mp
11464: WHERE mp.plan_id = p_sup_atp_info_rec.plan_id
11465: AND tp.sr_instance_id = mp.sr_instance_id
11466: AND tp.partner_type = 3
12643: s.weight_capacity weight,
12644: s.volume_capacity volume
12645: FROM msc_calendar_dates c,
12646: msc_interorg_ship_methods s,
12647: msc_trading_partners tp,
12648: msc_plans p
12649: WHERE s.plan_id = p_plan_id
12650: AND s.from_organization_id = p_from_organization_id
12651: AND s.to_organization_id = p_to_organization_id
13041: null col29 -- end_pegging_id
13042: FROM
13043: msc_calendar_dates c,
13044: msc_interorg_ship_methods s,
13045: msc_trading_partners tp,
13046: msc_plans p
13047: WHERE
13048: s.plan_id = p_plan_id
13049: AND s.from_organization_id = p_from_organization_id
13201: null col29 -- end_pegging_id
13202: FROM
13203: msc_calendar_dates c,
13204: msc_interorg_ship_methods s,
13205: msc_trading_partners tp,
13206: msc_plans p
13207: WHERE
13208: s.plan_id = p_plan_id
13209: AND s.from_organization_id = p_from_organization_id