APPS.MRP_MANAGER_PK dependencies on MRP_FORECAST_DATES

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

1974: creation_date,
1975: created_by,
1976: last_update_login
1977: )
1978: SELECT /*+ index (dates MRP_FORECAST_DATES_N1) */
1979: DISTINCT inventory_item_id,
1980: organization_id,
1981: forecast_designator,
1982: SYSDATE,

Line 1987: FROM mrp_forecast_dates dates

1983: 1,
1984: SYSDATE,
1985: 1,
1986: -1
1987: FROM mrp_forecast_dates dates
1988: WHERE NOT EXISTS
1989: (SELECT NULL
1990: FROM mrp_forecast_items items
1991: WHERE items.organization_id = dates.organization_id

Line 2010: UPDATE mrp_forecast_dates dates1

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

Line 2037: mrp_forecast_dates dates2

2033: 2, dates2.task_id,
2034: NULL),
2035: NULL)
2036: FROM mtl_parameters mtl,
2037: mrp_forecast_dates dates2
2038: WHERE dates2.transaction_id = dates1.old_transaction_id
2039: AND dates1.organization_id = mtl.organization_id)
2040: WHERE dates1.old_transaction_id >= 0;
2041:

Line 2044: UPDATE mrp_forecast_dates

2040: WHERE dates1.old_transaction_id >= 0;
2041:
2042: arg_row_count := SQL%ROWCOUNT;
2043:
2044: UPDATE mrp_forecast_dates
2045: SET to_update = null
2046: WHERE old_transaction_id >= 0;
2047:
2048: END update_forecast_desc_flex;

Line 2090: mrp_forecast_dates fc_dates

2086: 2, fc_dates.task_id,
2087: NULL),
2088: NULL)
2089: FROM mtl_parameters mtl,
2090: mrp_forecast_dates fc_dates
2091: WHERE fc_dates.transaction_id = dates.old_transaction_id
2092: AND dates.organization_id = mtl.organization_id)
2093: WHERE dates.old_transaction_id >= 0
2094: AND (dates.schedule_origination_type = 2