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.OE_HOLDS_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 465: FROM wf_item_activity_statuses wias_to,

461: IS
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,

Line 468: wf_item_activity_statuses wias_from,

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,
471: wf_items wi
472: WHERE wpa_to.instance_id= wias_to.process_activity

Line 603: FROM wf_item_activity_statuses wias_to,

599:
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,

Line 606: wf_item_activity_statuses wias_from,

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
609: WHERE wpa_to.instance_id= wias_to.process_activity
610: AND wat.to_process_activity = wpa_to.instance_id

Line 632: FROM wf_item_activity_statuses wias_to,

628: ELSE --16626753
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,

Line 635: wf_item_activity_statuses wias_from,

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
638: WHERE wpa_to.instance_id= wias_to.process_activity
639: AND wat.to_process_activity = wpa_to.instance_id

Line 686: FROM wf_item_activity_statuses wias_to,

682:
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,

Line 689: wf_item_activity_statuses_h wias_from,

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
692: WHERE wpa_to.instance_id= wias_to.process_activity
693: AND wat.to_process_activity = wpa_to.instance_id

Line 845: FROM wf_item_activity_statuses wias_to,

841:
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,

Line 848: wf_item_activity_statuses wias_from,

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
851: WHERE wpa_to.instance_id= wias_to.process_activity
852: AND wat.to_process_activity = wpa_to.instance_id

Line 896: FROM wf_item_activity_statuses wias_to,

892:
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,

Line 899: wf_item_activity_statuses_h wias_from,

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
902: WHERE wpa_to.instance_id= wias_to.process_activity
903: AND wat.to_process_activity = wpa_to.instance_id

Line 1097: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

1093: where oh.header_id = h.header_id
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)

Line 1186: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

1182: where oh.header_id = h.header_id
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)

Line 1370: l_sqlmt :=l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

1366: where oh.header_id = h.header_id
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)

Line 1476: l_sqlmt :=l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

1472: and oh.line_id = ol.line_id
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)

Line 9132: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

9128: where oh.header_id = h.header_id
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)

Line 9209: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

9205: and oh.line_id = ol.line_id
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)

Line 9459: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

9455: where oh.header_id = h.header_id
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)

Line 9530: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

9526: where oh.header_id = h.header_id
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)

Line 9674: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

9670: where oh.header_id = h.header_id
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)

Line 9747: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

9743: where oh.header_id = h.header_id
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)

Line 9889: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

9885: where oh.header_id = h.header_id
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)

Line 9961: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

9957: where oh.header_id = h.header_id
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)

Line 10102: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

10098: where oh.header_id = h.header_id
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)

Line 10175: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

10171: where oh.header_id = h.header_id
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)

Line 10338: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

10334: where oh.header_id = h.header_id
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)

Line 10410: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

10406: where oh.header_id = h.header_id
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)

Line 10850: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

10846: where oh.header_id = h.header_id
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)

Line 10923: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

10919: where oh.header_id = h.header_id
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)

Line 11155: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

11151: WHERE oh.header_id = h.header_id
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)

Line 11228: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

11224: WHERE oh.header_id = h.header_id
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)

Line 11370: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

11366: WHERE oh.header_id = h.header_id
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)

Line 11442: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

11438: WHERE oh.header_id = h.header_id
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)

Line 11587: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

11583: where oh.header_id = h.header_id
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)

Line 11659: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

11655: where oh.header_id = h.header_id
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)

Line 11911: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

11907: where oh.header_id = h.header_id
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)

Line 11983: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

11979: where oh.header_id = h.header_id
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)

Line 12126: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

12122: where oh.header_id = h.header_id
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)

Line 12198: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

12194: where oh.header_id = h.header_id
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)

Line 12340: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

12336: where oh.header_id = h.header_id
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)

Line 12412: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

12408: where oh.header_id = h.header_id
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)

Line 12552: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

12548: where oh.header_id = h.header_id
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)

Line 12623: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

12619: where oh.header_id = h.header_id
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)

Line 12741: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

12737: from oe_order_holds_ALL oh
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)

Line 12804: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

12800: where oh.header_id = h.header_id
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)

Line 13017: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

13013: from oe_order_holds_ALL oh
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)

Line 13075: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

13071: from oe_order_holds_ALL oh
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)

Line 13469: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

13465: where oh.header_id = h.header_id
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)

Line 13540: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

13536: where oh.header_id = h.header_id
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)

Line 13682: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

13678: where oh.header_id = h.header_id
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)

Line 13752: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

13748: where oh.header_id = h.header_id
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)

Line 13893: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

13889: where oh.header_id = h.header_id
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)

Line 13963: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

13959: where oh.header_id = h.header_id
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)

Line 14104: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

14100: where oh.header_id = h.header_id
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)

Line 14175: l_sqlmt := l_sqlmt||' and not exists (select 1 from wf_item_activity_statuses was

14171: where oh.header_id = h.header_id
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)