DBA Data[Home] [Help]

APPS.MSC_ATP_DB_UTILS dependencies on MSC_SYSTEM_ITEMS

Line 4030: MSC_SYSTEM_ITEMS I,

4026: BULK COLLECT INTO l_instance_id, l_organization_id, l_inventory_item_id, l_demand_class, l_sd_date, l_sd_qty
4027: FROM
4028: MSC_SALES_ORDERS D,
4029: MSC_ATP_RULES R,
4030: MSC_SYSTEM_ITEMS I,
4031: MSC_TRADING_PARTNERS P,
4032: msc_calendar_dates C,
4033: MSC_CALENDAR_DATES C2
4034: WHERE D.DEMAND_SOURCE_LINE = TO_CHAR(P_IDENTIFIER)

Line 5581: MSC_SYSTEM_ITEMS I,

5577: BULK COLLECT INTO l_instance_id, l_organization_id, l_inventory_item_id, l_demand_class, l_sd_date, l_sd_qty
5578: FROM
5579: MSC_SALES_ORDERS D,
5580: MSC_ATP_RULES R,
5581: MSC_SYSTEM_ITEMS I,
5582: MSC_TRADING_PARTNERS P,
5583: msc_calendar_dates C,
5584: MSC_CALENDAR_DATES C2
5585: WHERE D.DEMAND_SOURCE_LINE = TO_CHAR(P_IDENTIFIER)