DBA Data[Home] [Help]

APPS.MSC_ATP_DB_UTILS dependencies on MSC_CALENDAR_DATES

Line 4214: msc_calendar_dates C,

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)
4217: AND decode(demand_source_type,100,demand_source_type,-1)
4218: =decode(p_demand_source_type,

Line 4215: MSC_CALENDAR_DATES C2

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)
4217: AND decode(demand_source_type,100,demand_source_type,-1)
4218: =decode(p_demand_source_type,
4219: 100,

Line 5787: msc_calendar_dates C,

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)
5790: AND decode(demand_source_type,100,demand_source_type,-1)
5791: =decode(p_demand_source_type,

Line 5788: MSC_CALENDAR_DATES C2

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)
5790: AND decode(demand_source_type,100,demand_source_type,-1)
5791: =decode(p_demand_source_type,
5792: 100,