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.MRP_UPDATE_MRP_INFO_PK dependencies on MRP_RELIEF_INTERFACE

Line 46: mrp_relief_interface mrp

42: jobs.wip_entity_id,
43: jobs.organization_id
44: FROM wip_requirement_operations ops,
45: wip_discrete_jobs jobs,
46: mrp_relief_interface mrp
47: WHERE ops.wip_entity_id (+) = jobs.wip_entity_id
48: AND ops.organization_id (+) = jobs.organization_id
49: AND mrp.disposition_type = R_WORK_ORDER
50: AND mrp.relief_type = MPS_RELIEF_TYPE

Line 73: mrp_relief_interface mrp

69: SELECT fs.rowid,
70: fs.wip_entity_id,
71: fs.organization_id
72: FROM wip_flow_schedules fs,
73: mrp_relief_interface mrp
74: WHERE mrp.disposition_type = R_FLOW_SCHEDULE
75: AND mrp.relief_type = MPS_RELIEF_TYPE
76: AND mrp.request_id = arg_request_id
77: AND mrp.process_status = IN_PROCESS

Line 100: mrp_relief_interface mrp

96: where ms.rowid in (
97: SELECT /*+ INDEX(supply MTL_SUPPLY_N7) */
98: supply.rowid
99: FROM mtl_supply supply,
100: mrp_relief_interface mrp
101: WHERE mrp.disposition_type = R_PURCH_REQ
102: AND mrp.relief_type = MPS_RELIEF_TYPE
103: AND mrp.inventory_item_id =
104: DECODE(arg_item_id, NULL_VALUE, inventory_item_id,

Line 122: mrp_relief_interface mrp

118: UNION
119: SELECT /*+ INDEX(supply MTL_SUPPLY_N5) */
120: supply.rowid
121: FROM mtl_supply supply,
122: mrp_relief_interface mrp
123: WHERE mrp.disposition_type = R_PURCH_ORDER
124: AND mrp.relief_type = MPS_RELIEF_TYPE
125: AND mrp.inventory_item_id =
126: DECODE(arg_item_id, NULL_VALUE, inventory_item_id,

Line 144: mrp_relief_interface mrp

140: UNION
141: SELECT /*+ INDEX(supply MTL_SUPPLY_N9) */
142: supply.rowid
143: FROM mtl_supply supply,
144: mrp_relief_interface mrp
145: WHERE mrp.disposition_type = R_SHIPMENT
146: AND mrp.relief_type = MPS_RELIEF_TYPE
147: AND mrp.inventory_item_id =
148: DECODE(arg_item_id, NULL_VALUE, inventory_item_id,

Line 166: mrp_relief_interface mrp

162: UNION
163: SELECT /*+ INDEX(supply MTL_SUPPLY_N5) */
164: supply.rowid
165: FROM mtl_supply supply,
166: mrp_relief_interface mrp
167: WHERE mrp.disposition_type = R_PO_RECV
168: AND mrp.relief_type = MPS_RELIEF_TYPE
169: AND mrp.inventory_item_id =
170: DECODE(arg_item_id, NULL_VALUE, inventory_item_id,

Line 188: mrp_relief_interface mrp

184: UNION
185: SELECT /*+ INDEX(supply MTL_SUPPLY_N9) */
186: supply.rowid
187: FROM mtl_supply supply,
188: mrp_relief_interface mrp
189: WHERE mrp.disposition_type = R_SHIPMENT_RCV
190: AND mrp.relief_type = MPS_RELIEF_TYPE
191: AND mrp.inventory_item_id =
192: DECODE(arg_item_id, NULL_VALUE, inventory_item_id,

Line 234: from mrp_relief_interface mrp

230: AND desig.organization_id = plans.organization_id (+)
231: AND nvl(plans.planned_organization,
232: desig.organization_id) in
233: (select distinct mrp.organization_id
234: from mrp_relief_interface mrp
235: where
236: mrp.relief_type = MPS_RELIEF_TYPE
237: AND mrp.error_message is NULL
238: AND mrp.process_status = IN_PROCESS

Line 245: INDEX(mrp MRP_RELIEF_INTERFACE_N1)

241:
242: CURSOR recommendations_cursor IS
243: SELECT /* ORDERED
244: INDEX(recom MRP_RECOMMENDATIONS_N1)
245: INDEX(mrp MRP_RELIEF_INTERFACE_N1)
246: INDEX(plans MRP_PLANS_U1) */
247: recom.rowid
248: FROM mrp_recommendations recom
249: WHERE recom.new_order_quantity >= 0

Line 266: from mrp_relief_interface mrp

262: AND desig.organization_id = plans.organization_id
263: AND desig.designator = plans.compile_designator
264: AND plans.planned_organization in
265: (select distinct mrp.organization_id
266: from mrp_relief_interface mrp
267: where
268: mrp.relief_type = MPS_RELIEF_TYPE
269: AND mrp.error_message is NULL
270: AND mrp.process_status = IN_PROCESS