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 MTL_SUPPLY

Line 95: FROM mtl_supply ms

91: ORDER BY fs.organization_id, fs.wip_entity_id;
92:
93: CURSOR consol_cursor_ms IS
94: SELECT ms.rowid
95: FROM mtl_supply ms
96: where ms.rowid in (
97: SELECT /*+ INDEX(supply MTL_SUPPLY_N7) */
98: supply.rowid
99: FROM mtl_supply supply,

Line 97: SELECT /+ INDEX(supply MTL_SUPPLY_N7) /

93: CURSOR consol_cursor_ms IS
94: SELECT ms.rowid
95: FROM mtl_supply ms
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

Line 99: FROM mtl_supply supply,

95: FROM mtl_supply ms
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 =

Line 119: SELECT /+ INDEX(supply MTL_SUPPLY_N5) /

115: AND mrp.error_message is NULL
116: AND mrp.process_status = IN_PROCESS
117: AND mrp.request_id = arg_request_id
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

Line 121: FROM mtl_supply supply,

117: AND mrp.request_id = arg_request_id
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 =

Line 141: SELECT /+ INDEX(supply MTL_SUPPLY_N9) /

137: AND mrp.error_message is NULL
138: AND mrp.request_id = arg_request_id
139: AND mrp.process_status = IN_PROCESS
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

Line 143: FROM mtl_supply supply,

139: AND mrp.process_status = IN_PROCESS
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 =

Line 163: SELECT /+ INDEX(supply MTL_SUPPLY_N5) /

159: AND mrp.error_message is NULL
160: AND mrp.process_status = IN_PROCESS
161: AND mrp.request_id = arg_request_id
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

Line 165: FROM mtl_supply supply,

161: AND mrp.request_id = arg_request_id
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 =

Line 185: SELECT /+ INDEX(supply MTL_SUPPLY_N9) /

181: AND mrp.error_message is NULL
182: AND mrp.process_status = IN_PROCESS
183: AND mrp.request_id = arg_request_id
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

Line 187: FROM mtl_supply supply,

183: AND mrp.request_id = arg_request_id
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 =

Line 422: 'ENTITY', 'mtl_supply', 'N');

418: mrp_print_pk.stop_watch(arg_request_id, var_watch_id, var_row_count);
419:
420: var_watch_id := mrp_print_pk.start_watch(
421: 'GEN-updated', arg_request_id, arg_user_id,
422: 'ENTITY', 'mtl_supply', 'N');
423:
424: var_row_count := 0;
425:
426: -- Req Cursor

Line 445: UPDATE mtl_supply supply

441:
442: FETCH consol_cursor_ms INTO var_rowid;
443: exit when consol_cursor_ms%notfound;
444:
445: UPDATE mtl_supply supply
446: SET mrp_expected_delivery_date = expected_delivery_date ,
447: mrp_primary_quantity = to_org_primary_quantity,
448: mrp_to_organization_id = to_organization_id,
449: mrp_destination_type_code = destination_type_code,