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_SELECT_ALL_FOR_RELEASE_PUB dependencies on MRP_FORM_QUERY

Line 137: | Delete rows from mrp_form_query. |

133: p_error_rows := l_error_rows;
134: p_succ_rows := p_total_rows - p_error_rows;
135:
136: /*---------------------------------------------------+
137: | Delete rows from mrp_form_query. |
138: +----------------------------------------------------*/
139:
140: delete mrp_form_query
141: where query_id = g_rec_query_id;

Line 140: delete mrp_form_query

136: /*---------------------------------------------------+
137: | Delete rows from mrp_form_query. |
138: +----------------------------------------------------*/
139:
140: delete mrp_form_query
141: where query_id = g_rec_query_id;
142:
143: delete mrp_form_query
144: where query_id = g_rep_query_id;

Line 143: delete mrp_form_query

139:
140: delete mrp_form_query
141: where query_id = g_rec_query_id;
142:
143: delete mrp_form_query
144: where query_id = g_rep_query_id;
145:
146:
147: EXCEPTION

Line 189: (SELECT number1 from mrp_form_query

185:
186: update mrp_recommendations
187: set release_errors = NULL
188: where transaction_id IN
189: (SELECT number1 from mrp_form_query
190: where
191: query_id = g_rec_query_id)
192: AND release_errors is NOT NULL;
193:

Line 204: (SELECT number1 from mrp_form_query

200:
201: update mrp_recommendations mr
202: set release_errors = l_mesg_str
203: where transaction_id IN
204: (SELECT number1 from mrp_form_query
205: where
206: query_id = g_rec_query_id)
207: and (inventory_item_id, organization_id) IN
208: (select inventory_item_id,

Line 218: (SELECT number1 from mrp_form_query

214: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ACTION_NONE');
215: update mrp_recommendations mr
216: set release_errors = l_mesg_str
217: where transaction_id IN
218: (SELECT number1 from mrp_form_query
219: where
220: query_id = g_rec_query_id)
221: and (((inventory_item_id, organization_id) IN
222: (select inventory_item_id,

Line 249: (SELECT number1 from mrp_form_query

245:
246: update mrp_recommendations mr
247: set release_errors = release_errors||l_mesg_str
248: where transaction_id IN
249: (SELECT number1 from mrp_form_query
250: where
251: query_id = g_rec_query_id)
252: and (inventory_item_id, organization_id) IN
253: (select flex.inventory_item_id,

Line 272: (SELECT number1 from mrp_form_query

268:
269: update mrp_recommendations mr
270: set release_errors = release_errors||l_mesg_str
271: where transaction_id IN
272: (SELECT number1 from mrp_form_query
273: where
274: query_id = g_rec_query_id)
275: AND organization_id IN (select organization_id
276: from mrp_cust_sup_org_v);

Line 288: (SELECT number1 from mrp_form_query

284:
285: update mrp_recommendations mr
286: set release_errors = release_errors||l_mesg_str
287: where transaction_id IN
288: (SELECT number1 from mrp_form_query
289: where
290: query_id = g_rec_query_id)
291: and (inventory_item_id, organization_id) IN
292: (select inventory_item_id, organization_id

Line 306: (SELECT number1 from mrp_form_query

302:
303: update mrp_recommendations mr
304: set release_errors = release_errors||l_mesg_str
305: where transaction_id IN
306: (SELECT number1 from mrp_form_query
307: where query_id = g_rec_query_id)
308: and mr.order_type =5
309: and mr.source_vendor_id is null
310: and mr.organization_id = nvl(mr.source_organization_id,mr.organization_id)

Line 329: (SELECT char1 from mrp_form_query

325:
326: update mrp_sugg_rep_schedules
327: set release_errors = NULL
328: where rowid IN
329: (SELECT char1 from mrp_form_query
330: where
331: query_id = g_rep_query_id)
332: AND release_errors is NOT NULL;
333:

Line 344: (SELECT char1 from mrp_form_query

340:
341: update mrp_sugg_rep_schedules msrs
342: set release_errors = l_mesg_str
343: where rowid IN
344: (SELECT char1 from mrp_form_query
345: where
346: query_id = g_rep_query_id)
347: and (inventory_item_id, organization_id) IN
348: (select inventory_item_id,

Line 365: (SELECT char1 from mrp_form_query

361:
362: update mrp_sugg_rep_schedules msrs
363: set release_errors = release_errors||l_mesg_str
364: where rowid IN
365: (SELECT char1 from mrp_form_query
366: where
367: query_id = g_rep_query_id)
368: AND organization_id IN (select organization_id
369: from mrp_cust_sup_org_v);

Line 383: (SELECT char1 from mrp_form_query

379:
380: update mrp_sugg_rep_schedules msrs
381: set release_errors = release_errors||l_mesg_str
382: where rowid IN
383: (SELECT char1 from mrp_form_query
384: where
385: query_id = g_rep_query_id)
386: and (inventory_item_id, organization_id) IN
387: (select inventory_item_id, organization_id

Line 401: * This function inserts rows in mrp_form_query for all the *

397:
398: END;
399:
400: /******************************************************************
401: * This function inserts rows in mrp_form_query for all the *
402: * transaction id of the records which need to be selected for *
403: * release. This is done for records in table mrp_recommendations. *
404: ******************************************************************/
405:

Line 415: SELECT MRP_FORM_QUERY_S.NEXTVAL

411: l_rows_processed INTEGER;
412: l_cursor INTEGER;
413:
414: CURSOR GET_QUERY_ID IS
415: SELECT MRP_FORM_QUERY_S.NEXTVAL
416: FROM DUAL;
417: BEGIN
418:
419: l_where_clause := p_where_clause;

Line 428: 'INSERT INTO mrp_form_query ( '||

424: CLOSE GET_QUERY_ID;
425:
426:
427: l_sql_stmt :=
428: 'INSERT INTO mrp_form_query ( '||
429: 'query_id, last_update_date, last_updated_by, '||
430: 'creation_date, created_by, number1)' ||
431: 'SELECT ' ||
432: g_rec_query_id || ',' ||

Line 463: * This function inserts rows in mrp_form_query for all the *

459:
460: END;
461:
462: /******************************************************************
463: * This function inserts rows in mrp_form_query for all the *
464: * transaction id of the records which need to be selected for *
465: * release. This is done for records in table *
466: * mrp_sugg_rep_schedules. *
467: ******************************************************************/

Line 478: SELECT MRP_FORM_QUERY_S.NEXTVAL

474: l_rows_processed INTEGER;
475: l_cursor INTEGER;
476:
477: CURSOR GET_QUERY_ID IS
478: SELECT MRP_FORM_QUERY_S.NEXTVAL
479: FROM DUAL;
480: BEGIN
481:
482: l_where_clause := p_where_clause;

Line 491: 'INSERT INTO mrp_form_query ( '||

487: CLOSE GET_QUERY_ID;
488:
489:
490: l_sql_stmt :=
491: 'INSERT INTO mrp_form_query ( '||
492: 'query_id, last_update_date, last_updated_by, '||
493: 'creation_date, created_by, number1,char1)' ||
494: 'SELECT ' ||
495: g_rep_query_id || ',' ||

Line 605: (SELECT number1 from mrp_form_query

601: and msi.inventory_item_id = mr.inventory_item_id
602: and msi.organization_id = mr.organization_id
603: and msi.compile_designator = mr.compile_designator)
604: where transaction_id IN
605: (SELECT number1 from mrp_form_query
606: where
607: query_id = g_rec_query_id)
608: AND mr.release_errors is NULL
609: AND mr.order_type = 5

Line 630: (SELECT number1 from mrp_form_query

626: and msi.inventory_item_id = mr.inventory_item_id
627: and msi.organization_id = mr.organization_id
628: and msi.compile_designator = mr.compile_designator)
629: where transaction_id IN
630: (SELECT number1 from mrp_form_query
631: where
632: query_id = g_rec_query_id)
633: AND mr.order_type = 5
634: AND mr.status = 0

Line 646: (SELECT number1 from mrp_form_query

642: from mrp_workbench_display_options
643: WHERE user_id = l_user_id),
644: mr.created_by = l_user_id
645: where transaction_id IN
646: (SELECT number1 from mrp_form_query
647: where
648: query_id = g_rec_query_id)
649: AND mr.order_type = 5
650: AND mr.implement_as = 3

Line 661: (select number1 from mrp_form_query

657: update mrp_recommendations mr
658: set implement_end_item_unit_number =
659: nvl(implement_end_item_unit_number,end_item_unit_number)
660: where transaction_id in
661: (select number1 from mrp_form_query
662: where query_id=g_rec_query_id)
663: and release_errors is null
664: and order_type =5
665: and (inventory_item_id, organization_id) in

Line 679: (select number1 from mrp_form_query

675: l_mesg_str := fnd_message.get_string('MRP', 'MRP_REL_ALL_UNIT_NUMBER');
676: update mrp_recommendations mr
677: set release_errors = release_errors || l_mesg_str
678: where transaction_id in
679: (select number1 from mrp_form_query
680: where query_id=g_rec_query_id)
681: and implement_end_item_unit_number is null
682: and (inventory_item_id, organization_id) in
683: (select inventory_item_id, organization_id

Line 704: (SELECT number1 from mrp_form_query

700: hr_organization_units per
701: where per.organization_id = mr.organization_id
702: and per.location_id = hr.location_id)
703: where transaction_id IN
704: (SELECT number1 from mrp_form_query
705: where
706: query_id = g_rec_query_id)
707: AND ((mr.order_type = 5 AND mr.implement_as = 2) OR
708: mr.order_type = 2)

Line 722: (SELECT number1 from mrp_form_query

718:
719: update mrp_recommendations mr
720: set release_errors = release_errors || l_mesg_str
721: where transaction_id IN
722: (SELECT number1 from mrp_form_query
723: where
724: query_id = g_rec_query_id)
725: AND ((mr.order_type = 5 AND mr.implement_as = 2) OR
726: mr.order_type = 2)

Line 738: (SELECT number1 from mrp_form_query

734: set release_errors = release_errors || l_mesg_str,
735: implement_as = NULL,
736: release_status = 2
737: where transaction_id IN
738: (SELECT number1 from mrp_form_query
739: where
740: query_id = g_rec_query_id)
741: AND ((mr.order_type = 5 AND mr.implement_as = 2) OR
742: mr.order_type = 2);

Line 780: (SELECT number1 from mrp_form_query

776: NULL,
777: nvl(mr.implement_task_id,
778: mr.task_id)))
779: where transaction_id IN
780: (SELECT number1 from mrp_form_query
781: where
782: query_id = g_rec_query_id)
783: AND mr.release_errors IS NULL
784: AND mr.order_type IN (2, 3, 5);

Line 798: (SELECT number1 from mrp_form_query

794:
795: update mrp_recommendations mr
796: set release_errors = release_errors || l_mesg_str
797: where transaction_id IN
798: (SELECT number1 from mrp_form_query
799: where
800: query_id = g_rec_query_id)
801: AND mr.implement_date is NULL
802: AND mr.release_errors is NULL;

Line 815: (SELECT number1 from mrp_form_query

811:
812: update mrp_recommendations mr
813: set release_errors = release_errors || l_mesg_str
814: where transaction_id IN
815: (SELECT number1 from mrp_form_query
816: where
817: query_id = g_rec_query_id)
818: and implement_project_id IS NULL
819: and order_type <>2

Line 832: (SELECT number1 from mrp_form_query

828:
829: update mrp_recommendations mr
830: set release_errors = release_errors || l_mesg_str
831: where transaction_id IN
832: (SELECT number1 from mrp_form_query
833: where
834: query_id = g_rec_query_id)
835: and implement_task_id IS NULL
836: and order_type <>2

Line 907: (SELECT number1 from mrp_form_query

903: DECODE(l_def_firm_jobs, 'Y',
904: 1, 2)),
905: NULL)
906: where transaction_id IN
907: (SELECT number1 from mrp_form_query
908: where
909: query_id = g_rec_query_id)
910: AND mr.release_errors IS NULL
911: AND mr.order_type IN (2, 3, 5);

Line 946: (SELECT number1 from mrp_form_query

942: number1 = DECODE(mr.order_type,
943: 5, mr.implement_quantity,
944: mr.number1)
945: where transaction_id IN
946: (SELECT number1 from mrp_form_query
947: where
948: query_id = g_rec_query_id)
949: AND mr.release_errors IS NULL
950: AND mr.order_type = 5;

Line 960: (select number1 from mrp_form_query

956: SET
957: load_type =decode(order_type, 5, decode(implement_as, 3, 1, 2, 8, null),
958: 3, 4, 2, 16, null)
959: where transaction_id in
960: (select number1 from mrp_form_query
961: where query_id = g_rec_query_id)
962: AND mr.release_status=1;
963:
964: /*--------------------------------------------------------------+

Line 975: (select number1 from mrp_form_query

971: implement_quantity = NULL,
972: implement_date = NULL,
973: release_status = 2
974: where transaction_id in
975: (select number1 from mrp_form_query
976: where query_id = g_rec_query_id)
977: and release_errors is not NULL;
978: --
979: /*______________________________________________________________+

Line 990: (select number1 from mrp_form_query

986: WHERE order_type IN (2,3,5)
987: AND nvl(release_status,2) = 1
988: AND release_errors is NULL
989: AND transaction_id in
990: (select number1 from mrp_form_query
991: where query_id = g_rec_query_id);
992: --
993: -- End of Change for bug 1826152
994: --

Line 1035: (SELECT char1 from mrp_form_query

1031: +1,
1032: msrs.implement_processing_days),
1033: release_status = 1
1034: where rowid IN
1035: (SELECT char1 from mrp_form_query
1036: where
1037: query_id = g_rep_query_id)
1038: AND msrs.release_errors is NULL;
1039:

Line 1052: (SELECT char1 from mrp_form_query

1048: update mrp_sugg_rep_schedules msrs
1049: set release_errors = release_errors || l_mesg_str,
1050: release_status = 2
1051: where rowid IN
1052: (SELECT char1 from mrp_form_query
1053: where
1054: query_id = g_rep_query_id)
1055: AND msrs.implement_date is NULL
1056: AND msrs.release_errors is NULL;

Line 1066: (SELECT char1 from mrp_form_query

1062: update mrp_sugg_rep_schedules msrs
1063: SET
1064: load_type=2
1065: where rowid IN
1066: (SELECT char1 from mrp_form_query
1067: where
1068: query_id = g_rep_query_id)
1069: AND release_status=1;
1070:

Line 1079: (SELECT char1 from mrp_form_query

1075: -- 2797945
1076: UPDATE mrp_sugg_rep_schedules
1077: SET status = 1
1078: WHERE rowid IN
1079: (SELECT char1 from mrp_form_query
1080: where
1081: query_id = g_rep_query_id)
1082: AND release_status = 1
1083: AND status <> 3

Line 1110: (SELECT number1 from mrp_form_query

1106: into
1107: l_rec_errors
1108: from mrp_recommendations
1109: where transaction_id IN
1110: (SELECT number1 from mrp_form_query
1111: where
1112: query_id = g_rec_query_id)
1113: and release_errors is NOT NULL;
1114:

Line 1121: (SELECT char1 from mrp_form_query

1117: into
1118: l_rep_errors
1119: from mrp_sugg_rep_schedules
1120: where rowid IN
1121: (SELECT char1 from mrp_form_query
1122: where
1123: query_id = g_rep_query_id)
1124: and release_errors is not NULL;
1125: