eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_MDS_RELIEF_EXT dependencies on MRP_SCHEDULE_DATES

Line 43: FROM mrp_schedule_dates

39: AND schedule_type = 1
40: AND nvl(disable_date , trunc(sysdate) + 1) > trunc(sysdate)
41: AND NOT EXISTS (
42: SELECT null
43: FROM mrp_schedule_dates
44: WHERE mps_transaction_id = P_mds_rec.mps_transaction_id
45: AND schedule_designator = s.schedule_designator )
46: /*
47: AND schedule_designator IN ('' , ')

Line 62: FROM mrp_schedule_dates

58: --
59: CURSOR e ( X_schedule_designator VARCHAR2 ) IS
60: SELECT mps_transaction_id
61: , schedule_quantity
62: FROM mrp_schedule_dates
63: WHERE schedule_designator = X_schedule_designator
64: AND organization_id = P_mds_rec.organization_id
65: AND inventory_item_id = P_mds_rec.inventory_item_id
66: AND mps_transaction_id <> P_mds_rec.mps_transaction_id

Line 118: update mrp_schedule_dates

114:
115: --
116: -- The following updates the MDS record with the new quantity
117: --
118: update mrp_schedule_dates
119: set schedule_quantity = l_new_demand_qty
120: , last_update_date = sysdate
121: , last_updated_by = fnd_global.user_id
122: , request_id = fnd_global.conc_request_id