APPS.MRP_MANAGER_PK dependencies on MRP_FORECAST_DATES

Line 1983: SELECT /*+ index (dates MRP_FORECAST_DATES_N1) */

1979: creation_date,
1980: created_by,
1981: last_update_login
1982: )
1983: SELECT /*+ index (dates MRP_FORECAST_DATES_N1) */
1984: DISTINCT inventory_item_id,
1985: organization_id,
1986: forecast_designator,
1987: SYSDATE,

Line 1992: FROM mrp_forecast_dates dates

1988: 1,
1989: SYSDATE,
1990: 1,
1991: -1
1992: FROM mrp_forecast_dates dates
1993: WHERE NOT EXISTS
1994: (SELECT NULL
1995: FROM mrp_forecast_items items
1996: WHERE items.organization_id = dates.organization_id

Line 2015: UPDATE mrp_forecast_dates dates1

2011: | Copy comments, desc flex, project, and line reference |
2012: | For line reference, copy only if for the same org |
2013: +------------------------------------------------------*/
2014:
2015: UPDATE mrp_forecast_dates dates1
2016: SET (ddf_context, attribute_category,
2017: attribute1, attribute2, attribute3,
2018: attribute4, attribute5, attribute6,
2019: attribute7, attribute8, attribute9,

Line 2042: mrp_forecast_dates dates2

2038: 2, dates2.task_id,
2039: NULL),
2040: NULL)
2041: FROM mtl_parameters mtl,
2042: mrp_forecast_dates dates2
2043: WHERE dates2.transaction_id = dates1.old_transaction_id
2044: AND dates1.organization_id = mtl.organization_id)
2045: WHERE dates1.old_transaction_id >= 0;
2046:

Line 2049: UPDATE mrp_forecast_dates

2045: WHERE dates1.old_transaction_id >= 0;
2046:
2047: arg_row_count := SQL%ROWCOUNT;
2048:
2049: UPDATE mrp_forecast_dates
2050: SET to_update = null
2051: WHERE old_transaction_id >= 0;
2052:
2053: END update_forecast_desc_flex;

Line 2095: mrp_forecast_dates fc_dates

2091: 2, fc_dates.task_id,
2092: NULL),
2093: NULL)
2094: FROM mtl_parameters mtl,
2095: mrp_forecast_dates fc_dates
2096: WHERE fc_dates.transaction_id = dates.old_transaction_id
2097: AND dates.organization_id = mtl.organization_id)
2098: WHERE dates.old_transaction_id >= 0
2099: AND (dates.schedule_origination_type = 2