[Home] [Help]
462: SELECT wpa_to.process_name || ':' || wpa_to.activity_name full_activity_name,
463: wias_to.item_type,
464: wias_to.item_key
465: FROM wf_item_activity_statuses wias_to,
466: wf_process_activities wpa_to,
467: wf_activities wa,
468: wf_item_activity_statuses wias_from,
469: wf_process_activities wpa_from,
470: wf_activity_transitions wat,
465: FROM wf_item_activity_statuses wias_to,
466: wf_process_activities wpa_to,
467: wf_activities wa,
468: wf_item_activity_statuses wias_from,
469: wf_process_activities wpa_from,
470: wf_activity_transitions wat,
471: wf_items wi
472: WHERE wpa_to.instance_id= wias_to.process_activity
473: AND wat.to_process_activity = wpa_to.instance_id
600: SELECT wpa_to.process_name || ':' || wpa_to.activity_name,
601: wias_to.item_type
602: INTO l_activity, l_item_type
603: FROM wf_item_activity_statuses wias_to,
604: wf_process_activities wpa_to,
605: wf_activities wa,
606: wf_item_activity_statuses wias_from,
607: wf_process_activities wpa_from,
608: wf_activity_transitions wat
603: FROM wf_item_activity_statuses wias_to,
604: wf_process_activities wpa_to,
605: wf_activities wa,
606: wf_item_activity_statuses wias_from,
607: wf_process_activities wpa_from,
608: wf_activity_transitions wat
609: WHERE wpa_to.instance_id= wias_to.process_activity
610: AND wat.to_process_activity = wpa_to.instance_id
611: AND wat.result_code = 'ON_HOLD'
629: SELECT wpa_to.process_name || ':' || wpa_to.activity_name,
630: wias_to.item_type
631: INTO l_activity, l_item_type
632: FROM wf_item_activity_statuses wias_to,
633: wf_process_activities wpa_to,
634: wf_activities wa,
635: wf_item_activity_statuses wias_from,
636: wf_process_activities wpa_from,
637: wf_activity_transitions wat
632: FROM wf_item_activity_statuses wias_to,
633: wf_process_activities wpa_to,
634: wf_activities wa,
635: wf_item_activity_statuses wias_from,
636: wf_process_activities wpa_from,
637: wf_activity_transitions wat
638: WHERE wpa_to.instance_id= wias_to.process_activity
639: AND wat.to_process_activity = wpa_to.instance_id
640: AND wat.result_code = 'ON_HOLD'
683: SELECT wpa_to.process_name || ':' || wpa_to.activity_name,
684: wias_to.item_type
685: INTO l_activity, l_item_type
686: FROM wf_item_activity_statuses wias_to,
687: wf_process_activities wpa_to,
688: wf_activities wa,
689: wf_item_activity_statuses_h wias_from,
690: wf_process_activities wpa_from,
691: wf_activity_transitions wat
686: FROM wf_item_activity_statuses wias_to,
687: wf_process_activities wpa_to,
688: wf_activities wa,
689: wf_item_activity_statuses_h wias_from,
690: wf_process_activities wpa_from,
691: wf_activity_transitions wat
692: WHERE wpa_to.instance_id= wias_to.process_activity
693: AND wat.to_process_activity = wpa_to.instance_id
694: AND wat.result_code = 'ON_HOLD'
842: SELECT wpa_to.process_name || ':' || wpa_to.activity_name,
843: wias_to.item_type
844: INTO l_activity, l_item_type
845: FROM wf_item_activity_statuses wias_to,
846: wf_process_activities wpa_to,
847: wf_activities wa,
848: wf_item_activity_statuses wias_from,
849: wf_process_activities wpa_from,
850: wf_activity_transitions wat
845: FROM wf_item_activity_statuses wias_to,
846: wf_process_activities wpa_to,
847: wf_activities wa,
848: wf_item_activity_statuses wias_from,
849: wf_process_activities wpa_from,
850: wf_activity_transitions wat
851: WHERE wpa_to.instance_id= wias_to.process_activity
852: AND wat.to_process_activity = wpa_to.instance_id
853: AND wat.result_code = 'ON_HOLD'
893: SELECT wpa_to.process_name || ':' || wpa_to.activity_name,
894: wias_to.item_type
895: INTO l_activity, l_item_type
896: FROM wf_item_activity_statuses wias_to,
897: wf_process_activities wpa_to,
898: wf_activities wa,
899: wf_item_activity_statuses_h wias_from,
900: wf_process_activities wpa_from,
901: wf_activity_transitions wat
896: FROM wf_item_activity_statuses wias_to,
897: wf_process_activities wpa_to,
898: wf_activities wa,
899: wf_item_activity_statuses_h wias_from,
900: wf_process_activities wpa_from,
901: wf_activity_transitions wat
902: WHERE wpa_to.instance_id= wias_to.process_activity
903: AND wat.to_process_activity = wpa_to.instance_id
904: AND wat.result_code = 'ON_HOLD'
1094: and oh.line_id IS NULL
1095: and oh.hold_source_id =:hold_source_id )';
1096: IF p_item_type is not null and p_activity_name is not null then
1097: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
1098: , wf_process_activities wpa
1099: where was.process_activity = wpa.instance_id
1100: and item_type = :p_item_type
1101: and item_key = to_char(h.header_id)
1102: and activity_name = :l_activity_name
1183: and oh.line_id IS NULL
1184: and oh.hold_source_id =:hold_source_id )';
1185: IF p_item_type is not null and p_activity_name is not null then
1186: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
1187: , wf_process_activities wpa
1188: where was.process_activity = wpa.instance_id
1189: and item_type = :p_item_type
1190: and item_key = to_char(h.header_id)
1191: and activity_name = :l_activity_name
1367: and oh.line_id = ol.line_id
1368: and oh.hold_source_id = :hold_source_id )';
1369: IF p_item_type is not null and p_activity_name is not null then
1370: l_sqlmt :=l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
1371: , wf_process_activities wpa
1372: where was.process_activity = wpa.instance_id
1373: and item_type = :p_item_type
1374: and item_key = to_char(ol.line_id)
1375: and activity_name = :l_activity_name
1473: and oh.hold_source_id =:hold_source_id )';
1474:
1475: IF p_item_type is not null and p_activity_name is not null then
1476: l_sqlmt :=l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
1477: , wf_process_activities wpa
1478: where was.process_activity = wpa.instance_id
1479: and item_type = :p_item_type
1480: and item_key = to_char(ol.line_id)
1481: and activity_name = :l_activity_name
9129: and oh.line_id = ol.line_id
9130: and oh.hold_source_id = :hold_source_id )';
9131: IF p_item_type is not null and p_activity_name is not null then
9132: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
9133: , wf_process_activities wpa
9134: where was.process_activity = wpa.instance_id
9135: and item_type = :p_item_type
9136: and item_key = to_char(ol.line_id)
9137: and activity_name = :l_activity_name
9206: and oh.hold_source_id =:hold_source_id )';
9207:
9208: IF p_item_type is not null and p_activity_name is not null then
9209: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
9210: , wf_process_activities wpa
9211: where was.process_activity = wpa.instance_id
9212: and item_type = :p_item_type
9213: and item_key = to_char(ol.line_id)
9214: and activity_name = :l_activity_name
9456: and oh.line_id = ol.line_id
9457: and oh.hold_source_id =:hold_source_id )';
9458: IF p_item_type is not null and p_activity_name is not null then
9459: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
9460: , wf_process_activities wpa
9461: where was.process_activity = wpa.instance_id
9462: and item_type = :p_item_type
9463: and item_key = to_char(ol.line_id)
9464: and activity_name = :l_activity_name
9527: and oh.line_id = ol.line_id
9528: and oh.hold_source_id =:hold_source_id )';
9529: IF p_item_type is not null and p_activity_name is not null then
9530: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
9531: , wf_process_activities wpa
9532: where was.process_activity = wpa.instance_id
9533: and item_type = :p_item_type
9534: and item_key = to_char(ol.line_id)
9535: and activity_name = :l_activity_name
9671: and oh.line_id = ol.line_id
9672: and oh.hold_source_id = :hold_source_id )';
9673: IF p_item_type is not null and p_activity_name is not null then
9674: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
9675: , wf_process_activities wpa
9676: where was.process_activity = wpa.instance_id
9677: and item_type = :p_item_type
9678: and item_key = to_char(ol.line_id)
9679: and activity_name = :l_activity_name
9744: and oh.line_id = ol.line_id
9745: and oh.hold_source_id = :hold_source_id )';
9746: IF p_item_type is not null and p_activity_name is not null then
9747: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
9748: , wf_process_activities wpa
9749: where was.process_activity = wpa.instance_id
9750: and item_type = :p_item_type
9751: and item_key = to_char(ol.line_id)
9752: and activity_name = :l_activity_name
9886: and oh.line_id = ol.line_id
9887: and oh.hold_source_id =:hold_source_id )';
9888: IF p_item_type is not null and p_activity_name is not null then
9889: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
9890: , wf_process_activities wpa
9891: where was.process_activity = wpa.instance_id
9892: and item_type = :p_item_type
9893: and item_key = to_char(ol.line_id)
9894: and activity_name = :l_activity_name
9958: and oh.line_id = ol.line_id
9959: and oh.hold_source_id =:hold_source_id )';
9960: IF p_item_type is not null and p_activity_name is not null then
9961: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
9962: , wf_process_activities wpa
9963: where was.process_activity = wpa.instance_id
9964: and item_type = :p_item_type
9965: and item_key = to_char(ol.line_id)
9966: and activity_name = :l_activity_name
10099: and oh.line_id = ol.line_id
10100: and oh.hold_source_id =:hold_source_id )';
10101: IF p_item_type is not null and p_activity_name is not null then
10102: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
10103: , wf_process_activities wpa
10104: where was.process_activity = wpa.instance_id
10105: and item_type = :p_item_type
10106: and item_key = to_char(ol.line_id)
10107: and activity_name = :l_activity_name
10172: and oh.line_id = ol.line_id
10173: and oh.hold_source_id =:hold_source_id )';
10174: IF p_item_type is not null and p_activity_name is not null then
10175: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
10176: , wf_process_activities wpa
10177: where was.process_activity = wpa.instance_id
10178: and item_type = :p_item_type
10179: and item_key = to_char(ol.line_id)
10180: and activity_name = :l_activity_name
10335: and oh.line_id = ol.line_id
10336: and oh.hold_source_id =:hold_source_id )';
10337: IF p_item_type is not null and p_activity_name is not null then
10338: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
10339: , wf_process_activities wpa
10340: where was.process_activity = wpa.instance_id
10341: and item_type = :p_item_type
10342: and item_key = to_char(ol.line_id)
10343: and activity_name = :l_activity_name
10407: and oh.line_id = ol.line_id
10408: and oh.hold_source_id =:hold_source_id )';
10409: IF p_item_type is not null and p_activity_name is not null then
10410: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
10411: , wf_process_activities wpa
10412: where was.process_activity = wpa.instance_id
10413: and item_type = :p_item_type
10414: and item_key = to_char(ol.line_id)
10415: and activity_name = :l_activity_name
10847: and oh.line_id = ol.line_id
10848: and oh.hold_source_id =:hold_source_id )';
10849: IF p_item_type is not null and p_activity_name is not null then
10850: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
10851: , wf_process_activities wpa
10852: where was.process_activity = wpa.instance_id
10853: and item_type = :p_item_type
10854: and item_key = to_char(ol.line_id)
10855: and activity_name = :l_activity_name
10920: and oh.line_id = ol.line_id
10921: and oh.hold_source_id =:hold_source_id )';
10922: IF p_item_type is not null and p_activity_name is not null then
10923: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
10924: , wf_process_activities wpa
10925: where was.process_activity = wpa.instance_id
10926: and item_type = :p_item_type
10927: and item_key = to_char(ol.line_id)
10928: and activity_name = :l_activity_name
11152: AND oh.line_id = ol.line_id
11153: AND oh.hold_source_id =:hold_source_id )';
11154: IF p_item_type is not null and p_activity_name is not null then
11155: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
11156: , wf_process_activities wpa
11157: where was.process_activity = wpa.instance_id
11158: and item_type = :p_item_type
11159: and item_key = to_char(ol.line_id)
11160: and activity_name = :l_activity_name
11225: AND oh.line_id = ol.line_id
11226: AND oh.hold_source_id =:hold_source_id )';
11227: IF p_item_type is not null and p_activity_name is not null then
11228: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
11229: , wf_process_activities wpa
11230: where was.process_activity = wpa.instance_id
11231: and item_type = :p_item_type
11232: and item_key = to_char(ol.line_id)
11233: and activity_name = :l_activity_name
11367: AND oh.line_id = ol.line_id
11368: AND oh.hold_source_id =:hold_source_id )';
11369: IF p_item_type is not null and p_activity_name is not null then
11370: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
11371: , wf_process_activities wpa
11372: where was.process_activity = wpa.instance_id
11373: and item_type = :p_item_type
11374: and item_key = to_char(ol.line_id)
11375: and activity_name = :l_activity_name
11439: AND oh.line_id = ol.line_id
11440: AND oh.hold_source_id =:hold_source_id )';
11441: IF p_item_type is not null and p_activity_name is not null then
11442: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
11443: , wf_process_activities wpa
11444: where was.process_activity = wpa.instance_id
11445: and item_type = :p_item_type
11446: and item_key = to_char(ol.line_id)
11447: and activity_name = :l_activity_name
11584: and oh.line_id = ol.line_id
11585: and oh.hold_source_id =:hold_source_id )';
11586: IF p_item_type is not null and p_activity_name is not null then
11587: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
11588: , wf_process_activities wpa
11589: where was.process_activity = wpa.instance_id
11590: and item_type = :p_item_type
11591: and item_key = to_char(ol.line_id)
11592: and activity_name = :l_activity_name
11656: and oh.line_id = ol.line_id
11657: and oh.hold_source_id =:hold_source_id )';
11658: IF p_item_type is not null and p_activity_name is not null then
11659: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
11660: , wf_process_activities wpa
11661: where was.process_activity = wpa.instance_id
11662: and item_type = :p_item_type
11663: and item_key = to_char(ol.line_id)
11664: and activity_name = :l_activity_name
11908: and oh.line_id = ol.line_id
11909: and oh.hold_source_id =:hold_source_id )';
11910: IF p_item_type is not null and p_activity_name is not null then
11911: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
11912: , wf_process_activities wpa
11913: where was.process_activity = wpa.instance_id
11914: and item_type = :p_item_type
11915: and item_key = to_char(ol.line_id)
11916: and activity_name = :l_activity_name
11980: and oh.line_id = ol.line_id
11981: and oh.hold_source_id =:hold_source_id )';
11982: IF p_item_type is not null and p_activity_name is not null then
11983: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
11984: , wf_process_activities wpa
11985: where was.process_activity = wpa.instance_id
11986: and item_type = :p_item_type
11987: and item_key = to_char(ol.line_id)
11988: and activity_name = :l_activity_name
12123: and oh.line_id = ol.line_id
12124: and oh.hold_source_id =:hold_source_id )';
12125: IF p_item_type is not null and p_activity_name is not null then
12126: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
12127: , wf_process_activities wpa
12128: where was.process_activity = wpa.instance_id
12129: and item_type = :p_item_type
12130: and item_key = to_char(ol.line_id)
12131: and activity_name = :l_activity_name
12195: and oh.line_id = ol.line_id
12196: and oh.hold_source_id =:hold_source_id )';
12197: IF p_item_type is not null and p_activity_name is not null then
12198: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
12199: , wf_process_activities wpa
12200: where was.process_activity = wpa.instance_id
12201: and item_type = :p_item_type
12202: and item_key = to_char(ol.line_id)
12203: and activity_name = :l_activity_name
12337: and oh.line_id = ol.line_id
12338: and oh.hold_source_id =:hold_source_id )';
12339: IF p_item_type is not null and p_activity_name is not null then
12340: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
12341: , wf_process_activities wpa
12342: where was.process_activity = wpa.instance_id
12343: and item_type = :p_item_type
12344: and item_key = to_char(ol.line_id)
12345: and activity_name = :l_activity_name
12409: and oh.line_id = ol.line_id
12410: and oh.hold_source_id =:hold_source_id )';
12411: IF p_item_type is not null and p_activity_name is not null then
12412: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
12413: , wf_process_activities wpa
12414: where was.process_activity = wpa.instance_id
12415: and item_type = :p_item_type
12416: and item_key = to_char(ol.line_id)
12417: and activity_name = :l_activity_name
12549: and oh.line_id = ol.line_id
12550: and oh.hold_source_id =:hold_source_id )';
12551: IF p_item_type is not null and p_activity_name is not null then
12552: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
12553: , wf_process_activities wpa
12554: where was.process_activity = wpa.instance_id
12555: and item_type = :p_item_type
12556: and item_key = to_char(ol.line_id)
12557: and activity_name = :l_activity_name
12620: and oh.line_id = ol.line_id
12621: and oh.hold_source_id =:hold_source_id )';
12622: IF p_item_type is not null and p_activity_name is not null then
12623: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
12624: , wf_process_activities wpa
12625: where was.process_activity = wpa.instance_id
12626: and item_type = :p_item_type
12627: and item_key = to_char(ol.line_id)
12628: and activity_name = :l_activity_name
12738: where oh.header_id = h.header_id
12739: and oh.hold_source_id =:hold_source_id2 )';
12740: IF p_item_type is not null and p_activity_name is not null then
12741: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
12742: , wf_process_activities wpa
12743: where was.process_activity = wpa.instance_id
12744: and item_type = :p_item_type
12745: and item_key = to_char(h.header_id)
12746: and activity_name = :l_activity_name
12801: and oh.line_id = ol.line_id
12802: and oh.hold_source_id =:hold_source_id )';
12803: IF p_item_type is not null and p_activity_name is not null then
12804: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
12805: , wf_process_activities wpa
12806: where was.process_activity = wpa.instance_id
12807: and item_type = :p_item_type
12808: and item_key = to_char(ol.line_id)
12809: and activity_name = :l_activity_name
13014: where oh.header_id = h.header_id
13015: and oh.hold_source_id =:hold_source_id )';
13016: IF p_item_type is not null and p_activity_name is not null then
13017: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
13018: , wf_process_activities wpa
13019: where was.process_activity = wpa.instance_id
13020: and item_type = :p_item_type
13021: and item_key = to_char(h.header_id)
13022: and activity_name = :l_activity_name
13072: where oh.header_id = h.header_id
13073: and oh.hold_source_id =:hold_source_id )';
13074: IF p_item_type is not null and p_activity_name is not null then
13075: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
13076: , wf_process_activities wpa
13077: where was.process_activity = wpa.instance_id
13078: and item_type = :p_item_type
13079: and item_key = to_char(h.header_id)
13080: and activity_name = :l_activity_name
13466: and oh.line_id = ol.line_id
13467: and oh.hold_source_id =:hold_source_id )';
13468: IF p_item_type is not null and p_activity_name is not null then
13469: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
13470: , wf_process_activities wpa
13471: where was.process_activity = wpa.instance_id
13472: and item_type = :p_item_type
13473: and item_key = to_char(ol.line_id)
13474: and activity_name = :l_activity_name
13537: and oh.line_id = ol.line_id
13538: and oh.hold_source_id =:hold_source_id )';
13539: IF p_item_type is not null and p_activity_name is not null then
13540: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
13541: , wf_process_activities wpa
13542: where was.process_activity = wpa.instance_id
13543: and item_type = :p_item_type
13544: and item_key = to_char(ol.line_id)
13545: and activity_name = :l_activity_name
13679: and oh.line_id = ol.line_id
13680: and oh.hold_source_id =:hold_source_id )';
13681: IF p_item_type is not null and p_activity_name is not null then
13682: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
13683: , wf_process_activities wpa
13684: where was.process_activity = wpa.instance_id
13685: and item_type = :p_item_type
13686: and item_key = to_char(ol.line_id)
13687: and activity_name = :l_activity_name
13749: and oh.line_id = ol.line_id
13750: and oh.hold_source_id =:hold_source_id )';
13751: IF p_item_type is not null and p_activity_name is not null then
13752: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
13753: , wf_process_activities wpa
13754: where was.process_activity = wpa.instance_id
13755: and item_type = :p_item_type
13756: and item_key = to_char(ol.line_id)
13757: and activity_name = :l_activity_name
13890: and oh.line_id = ol.line_id
13891: and oh.hold_source_id =:hold_source_id )';
13892: IF p_item_type is not null and p_activity_name is not null then
13893: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
13894: , wf_process_activities wpa
13895: where was.process_activity = wpa.instance_id
13896: and item_type = :p_item_type
13897: and item_key = to_char(ol.line_id)
13898: and activity_name = :l_activity_name
13960: and oh.line_id = ol.line_id
13961: and oh.hold_source_id =:hold_source_id )';
13962: IF p_item_type is not null and p_activity_name is not null then
13963: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
13964: , wf_process_activities wpa
13965: where was.process_activity = wpa.instance_id
13966: and item_type = :p_item_type
13967: and item_key = to_char(ol.line_id)
13968: and activity_name = :l_activity_name
14101: and oh.line_id = ol.line_id
14102: and oh.hold_source_id =:hold_source_id )';
14103: IF p_item_type is not null and p_activity_name is not null then
14104: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
14105: , wf_process_activities wpa
14106: where was.process_activity = wpa.instance_id
14107: and item_type = :p_item_type
14108: and item_key = to_char(ol.line_id)
14109: and activity_name = :l_activity_name
14172: and oh.line_id = ol.line_id
14173: and oh.hold_source_id =:hold_source_id )';
14174: IF p_item_type is not null and p_activity_name is not null then
14175: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was
14176: , wf_process_activities wpa
14177: where was.process_activity = wpa.instance_id
14178: and item_type = :p_item_type
14179: and item_key = to_char(ol.line_id)
14180: and activity_name = :l_activity_name