DBA Data[Home] [Help]

APPS.MSC_ATP_DB_UTILS dependencies on MSC_SYSTEM_ITEMS

Line 4212: MSC_SYSTEM_ITEMS I,

4208: BULK COLLECT INTO l_instance_id, l_organization_id, l_inventory_item_id, l_demand_class, l_sd_date, l_sd_qty
4209: FROM
4210: MSC_SALES_ORDERS D,
4211: MSC_ATP_RULES R,
4212: MSC_SYSTEM_ITEMS I,
4213: MSC_TRADING_PARTNERS P,
4214: msc_calendar_dates C,
4215: MSC_CALENDAR_DATES C2
4216: WHERE D.DEMAND_SOURCE_LINE = TO_CHAR(P_IDENTIFIER)

Line 5785: MSC_SYSTEM_ITEMS I,

5781: BULK COLLECT INTO l_instance_id, l_organization_id, l_inventory_item_id, l_demand_class, l_sd_date, l_sd_qty
5782: FROM
5783: MSC_SALES_ORDERS D,
5784: MSC_ATP_RULES R,
5785: MSC_SYSTEM_ITEMS I,
5786: MSC_TRADING_PARTNERS P,
5787: msc_calendar_dates C,
5788: MSC_CALENDAR_DATES C2
5789: WHERE D.DEMAND_SOURCE_LINE = TO_CHAR(P_IDENTIFIER)