[Home] [Help]
82: TYPE lpn_name_tab IS TABLE OF WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE
83: INDEX BY BINARY_INTEGER;
84: TYPE sub_name_tab IS TABLE OF MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE
85: INDEX BY BINARY_INTEGER;
86: TYPE row_type_tab IS TABLE OF WMS_PUTAWAY_GROUP_TASKS_GTMP.ROW_TYPE%TYPE
87: INDEX BY BINARY_INTEGER;
88: TYPE item_tab IS TABLE OF MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE
89: INDEX BY BINARY_INTEGER;
90:
218:
219:
220: /**
221: * This function will get the count of number of rows in the
222: * global temporary table WMS_PUTAWAY_GROUP_TASKS_GTMP
223: * The rows counted will depend on the mode for which it is called
224: * Mode Meaning
225: * ----------------------------------------------------------------
226: * 1 Get the count of all the rows in the temp table
254: -- Get the count of all rows in the temp table
255: l_progress := '100';
256: SELECT count(ROWID)
257: INTO l_rec_count
258: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP;
259: l_progress := '110';
260:
261: ELSIF (p_mode = 2) THEN
262:
263: -- Get the count of all 'All Task' Rows in the temp table
264: l_progress := '200';
265: SELECT count(ROWID)
266: INTO l_rec_count
267: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
268: WHERE row_type = G_ROW_TP_ALL_TASK;
269: l_progress := '210';
270:
271: ELSIF (p_mode = 3) THEN
273: -- Get the count of all 'Group Task' Rows in the temp table
274: l_progress := '300';
275: SELECT count(ROWID)
276: INTO l_rec_count
277: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
278: WHERE row_type = G_ROW_TP_GROUP_TASK;
279: l_progress := '310';
280:
281: ELSIF (p_mode = 4) THEN
283: -- Get the count of all 'LPN Task' Rows in the temp table
284: l_progress := '400';
285: SELECT count(ROWID)
286: INTO l_rec_count
287: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
288: WHERE row_type = G_ROW_TP_LPN_TASK;
289: l_progress := '410';
290:
291: ELSE
321:
322:
323: /**
324: * This function will remove all the records in the temporary
325: * table WMS_PUTAWAY_GROUP_TASKS_GTMP
326: * The rows that has to be deleted depends on the i/p parameter
327: * p_del_type
328: *
329: * p_del_type Action
355:
356: -- This cursor will select the dummy rows in the temp table which can be deleted
357: CURSOR c_dummy_task IS
358: SELECT ROWID
359: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
360: WHERE row_type = G_ROW_TP_LPN_TASK;
361:
362:
363: BEGIN
387: RETURN -1;
388: END IF;
389:
390: l_progress := '110';
391: DELETE FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
392: WHERE group_id = p_group_id;
393: l_progress := '120';
394:
395: -- Get the number of rows processed by the above SQL
424:
425:
426: -- Bulk delete the dummy records
427: FORALL i IN 1 .. l_rowid_tab.COUNT
428: DELETE FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
429: WHERE ROWID = l_rowid_tab(i);
430:
431: l_progress := '260';
432: END LOOP; --dummy_task_cursor
436: l_progress := '280';
437:
438:
439: ELSIF p_del_type = 3 THEN
440: --Delete all records from WMS_PUTAWAY_GROUP_TASKS_GTMP
441:
442: l_progress := '305';
443: IF (l_debug = 1) THEN
444: DEBUG(' Deleting all the rows from the global temp table',l_proc_name,9);
444: DEBUG(' Deleting all the rows from the global temp table',l_proc_name,9);
445: END IF;
446:
447: l_progress := '310';
448: DELETE FROM WMS_PUTAWAY_GROUP_TASKS_GTMP;
449: l_progress := '320';
450:
451: -- Get the number of rows processed by the above SQL
452: l_progress := '330';
510: l_txn_temp_id_tab num_tab;
511:
512: CURSOR c_all_group_tasks_cursor IS
513: SELECT drop_order
514: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
515: WHERE row_type = G_ROW_TP_GROUP_TASK;
516:
517: BEGIN
518:
539: INTO l_txn_header_id
540: FROM dual;
541: l_progress := '140';
542:
543: UPDATE WMS_PUTAWAY_GROUP_TASKS_GTMP
544: SET transaction_header_id = l_txn_header_id
545: ,group_id = l_drop_order
546: WHERE drop_order = l_drop_order
547: RETURNING transaction_temp_id
549: l_progress := '150';
550:
551: l_rec_count := l_rec_count + SQL%rowcount;
552: IF (l_debug = 1) THEN
553: DEBUG(sql%rowcount || ' Row(s) updated in WMS_PUTAWAY_GROUP_TASKS_GTMP with txn_header_id = ' || l_txn_header_id ||
554: ' and group_id = ' || l_drop_order
555: ,l_proc_name,9);
556: END IF;
557: l_progress := '160';
564: l_progress := '170';
565:
566: l_rec_count := l_rec_count + SQL%rowcount;
567: IF (l_debug = 1) THEN
568: DEBUG(sql%rowcount || ' Row(s) updated in WMS_PUTAWAY_GROUP_TASKS_GTMP with txn_header_id= ' || l_txn_header_id ,l_proc_name,9);
569: END IF;
570: l_progress := '180';
571:
572:
658: l_progress := '160';
659:
660: SELECT MIN(drop_order)
661: INTO l_min_drop_order
662: FROM wms_putaway_group_tasks_gtmp
663: WHERE lpn_id = p_lpn_id
664: OR lpn_id IN ( SELECT lpn_id
665: FROM wms_license_plate_numbers
666: START WITH lpn_id = p_lpn_id
668: );
669: l_progress := '170';
670:
671: --Update the cosolidated lpn for the child LPNs with the lpn passed
672: /* UPDATE wms_putaway_group_tasks_gtmp
673: SET consolidated_lpn_id = p_lpn_id
674: ,consolidated_lpn_name = l_lpn_name
675: ,drop_order = p_drop_order
676: WHERE lpn_id IN (SELECT lpn_id
681:
682:
683: -- Do bulk update for all LPN and all itz child the consolidated LPN and the min drop order in that group
684: FORALL i IN 1 .. l_lpn_id_tab.COUNT
685: UPDATE wms_putaway_group_tasks_gtmp
686: SET consolidated_lpn_id = p_lpn_id
687: ,consolidated_lpn_name = p_lpn_name
688: ,drop_order = l_min_drop_order
689: WHERE lpn_id = l_lpn_id_tab(i);
748: -- Select the parent lpn id of the passed lpn
749: l_progress := '100';
750: SELECT parent_lpn_id
751: INTO l_parent_lpn_id
752: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
753: WHERE lpn_id = p_lpn_id
754: AND ROWNUM < 2;
755: l_progress := '110';
756:
755: l_progress := '110';
756:
757: -- Set the drop type to 'ID' for all the contents of the lpn passed
758: l_progress := '120';
759: UPDATE WMS_PUTAWAY_GROUP_TASKS_GTMP
760: SET drop_type = G_DT_ITEM_DROP
761: WHERE lpn_id = p_lpn_id;
762: l_progress := '130';
763:
862: l_progress := '110';
863:
864: -- This will bulk insert consolidated records for group tasks into the temp table
865: FORALL i IN 1 .. l_rowid_tab.COUNT
866: INSERT INTO WMS_PUTAWAY_GROUP_TASKS_GTMP
867: (
868: ORGANIZATION_ID
869: ,TRANSACTION_TEMP_ID
870: ,TRANSACTION_HEADER_ID
1003: ,l_error_code_tab(i) --R12
1004: ,l_drop_lpn_option_tab(i) --R12
1005: ,l_consolidation_method_id_tab(i) --R12
1006: ,sub_lpn_controlled_flag --R12
1007: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
1008: WHERE ROWID = l_rowid_tab(i);
1009: l_progress := '120';
1010:
1011: l_rec_count := SQL%rowcount;
1066: ,MAX(show_message) --R12
1067: ,MAX(error_code) --R12
1068: ,MAX(drop_lpn_option) --R12: This value should be unique per group
1069: ,MAX(consolidation_method_id) --R12: This value should be unique per group
1070: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
1071: WHERE row_type IN (G_ROW_TP_ALL_TASK, G_ROW_TP_LPN_TASK)
1072: AND drop_type = G_DT_CONSOLIDATED_DROP
1073: GROUP BY drop_order;
1074:
1129: l_rec_count := l_rec_count + l_cur_count;
1130: l_progress := '235';
1131:
1132: IF (l_debug = 1) THEN
1133: DEBUG( l_cur_count|| ' Group task Row(s) inserted in WMS_PUTAWAY_GROUP_TASKS_GTMP '
1134: ,l_proc_name,9);
1135: END IF;
1136: l_progress := '240';
1137:
1245: ,MAX(show_message)
1246: ,MAX(error_code)
1247: ,MAX(drop_lpn_option) --R12: This value should be unique per group
1248: ,MAX(consolidation_method_id) --R12: This value should be unique per group
1249: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
1250: WHERE row_type = G_ROW_TP_ALL_TASK
1251: AND drop_type = G_DT_ITEM_DROP
1252: AND NOT (crossdock_type > 1
1253: AND backorder_delivery_detail > 0
1274: ,MAX(show_message)
1275: ,MAX(error_code)
1276: ,MAX(drop_lpn_option) --R12: This value should be unique per group
1277: ,MAX(consolidation_method_id) --R12: This value should be unique per group
1278: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
1279: WHERE row_type = G_ROW_TP_ALL_TASK
1280: AND drop_type = G_DT_ITEM_DROP
1281: AND crossdock_type > 1
1282: AND backorder_delivery_detail > 0
1315: ,WIP_ENTITY_TYPE
1316: ,WIP_START_DATE
1317: ,WIP_SCHEDULE
1318: ,WIP_ASSEMBLY
1319: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
1320: WHERE drop_type = G_DT_ITEM_DROP
1321: AND row_type = G_ROW_TP_GROUP_TASK;
1322:
1323: BEGIN
1379: l_rec_count := l_rec_count + l_cur_count;
1380: l_progress := '235';
1381:
1382: IF (l_debug = 1) THEN
1383: DEBUG( l_cur_count|| ' Group task Row(s) inserted in WMS_PUTAWAY_GROUP_TASKS_GTMP '
1384: ,l_proc_name,9);
1385: END IF;
1386: l_progress := '240';
1387:
1439: l_rec_count := l_rec_count + l_cur_count;
1440: l_progress := '335';
1441:
1442: IF (l_debug = 1) THEN
1443: DEBUG( l_cur_count|| ' Group task Row(s) inserted in WMS_PUTAWAY_GROUP_TASKS_GTMP for crossdocked to WIP ISSUE tasks'
1444: ,l_proc_name,9);
1445: END IF;
1446: l_progress := '340';
1447:
1484: l_progress := '620';
1485:
1486:
1487: FORALL i IN 1 ..l_lpn_id_tab.COUNT
1488: UPDATE WMS_PUTAWAY_GROUP_TASKS_GTMP
1489: SET drop_order = l_out_drop_order_tab(i)
1490: WHERE drop_type = G_DT_ITEM_DROP
1491: AND lpn_id = l_lpn_id_tab(i)
1492: AND inventory_item_id = l_inventory_item_id_tab(i)
1509: l_progress := '640';
1510:
1511: l_rec_count := l_rec_count + sql%rowcount;
1512: IF (l_debug = 1) THEN
1513: DEBUG(sql%rowcount || ' Group task Row(s) updated in WMS_PUTAWAY_GROUP_TASKS_GTMP '
1514: ,l_proc_name,9);
1515: END IF;
1516:
1517: l_progress := '650';
1695: -- For which the drop type is 'CD'
1696: CURSOR c_lpn_level_cursor IS
1697: SELECT DISTINCT
1698: lpn_level
1699: FROM wms_putaway_group_tasks_gtmp
1700: WHERE drop_type = G_DT_CONSOLIDATED_DROP
1701: ORDER BY lpn_level DESC;
1702:
1703: -- This cursor will get all the LPNs, their dest sub/loc and its parent lpn id where drop_type is CD
1721: ,WIP_ENTITY_TYPE
1722: ,WIP_START_DATE
1723: ,WIP_SCHEDULE
1724: ,WIP_ASSEMBLY
1725: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
1726: WHERE drop_type = G_DT_CONSOLIDATED_DROP
1727: AND lpn_level = v_lpn_level;
1728:
1729: -- This cursor will get the rowid, dest sub/loc for the lpn passed where drop type is CD
1743: ,WIP_ENTITY_TYPE
1744: ,WIP_START_DATE
1745: ,WIP_SCHEDULE
1746: ,WIP_ASSEMBLY
1747: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
1748: WHERE lpn_id = v_parent_lpn_id
1749: AND drop_type = G_DT_CONSOLIDATED_DROP
1750: AND ROWNUM < 2;
1751:
1758: CURSOR c_group_tasks_order_by IS
1759: SELECT wpgtt.ROWID
1760: ,ROWNUM
1761: ,wpgtt.lpn_id lpn_id
1762: FROM wms_putaway_group_tasks_gtmp wpgtt
1763: ORDER BY wpgtt.sub_dropping_order,
1764: wpgtt.dest_subinventory,
1765: wpgtt.loc_dropping_order,
1766: wpgtt.LOCATOR,
1844: END IF;
1845: END;
1846:
1847: -- update the drop order and LPN columns back to temp table
1848: UPDATE wms_putaway_group_tasks_gtmp
1849: SET drop_order = l_drop_order
1850: ,lpn_name = l_lpn_name_tab(i)
1851: ,parent_lpn_id = l_parent_lpn_id_tab(i)
1852: ,parent_lpn_name = l_parent_lpn_name_tab(i)
2116: ,l_wip_entity_type_count
2117: ,l_wip_start_date_count
2118: ,l_wip_schedule_count
2119: ,l_wip_assembly_count
2120: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
2121: WHERE row_type = G_ROW_TP_ALL_TASK
2122: AND crossdock_type > 1
2123: AND backorder_delivery_detail > 0
2124: AND wip_supply_type = 1
2208: (l_wip_supply_type <> 1) ) THEN
2209: l_progress := '350';
2210:
2211: -- Dest sub/loc of the parent is null and hence update the dest sub/loc with that of childs
2212: UPDATE WMS_PUTAWAY_GROUP_TASKS_GTMP
2213: SET dest_subinventory = l_dest_sub_tab(i)
2214: ,dest_locator = l_dest_loc_tab(i)
2215: ,into_lpn_id = l_into_lpn_id_tab(i)
2216: ,into_lpn_name = l_into_lpn_name_tab(i)
2345: BEGIN
2346: UPDATE mtl_material_transactions_temp
2347: SET cartonization_id = NULL
2348: WHERE transaction_temp_id IN (SELECT gtmp.transaction_temp_id
2349: FROM wms_putaway_group_tasks_gtmp gtmp
2350: WHERE gtmp.consolidation_method_id = 1 --???MDC
2351: AND gtmp.drop_type = g_dt_item_drop);
2352:
2353: IF (l_debug = 1) THEN
2353: IF (l_debug = 1) THEN
2354: DEBUG('Num of MMTT rows updated:' ||SQL%rowcount,l_proc_name,4);
2355: END IF;
2356:
2357: UPDATE wms_putaway_group_tasks_gtmp
2358: SET consolidation_method_id = 0
2359: WHERE consolidation_method_id = 1
2360: AND drop_type = g_dt_item_drop;
2361:
2412:
2413:
2414: /**
2415: * This function will populate the global temporary table
2416: * WMS_PUTAWAY_GROUP_TASKS_GTMP with the required data and
2417: * will return the count of rows in the temporary table as
2418: * output.
2419:
2420: * This method will also insert the dummy records for those
2526: ,transaction_temp_id
2527: ,organization_id
2528: ,Nvl(crossdock_type,0)
2529: ,Nvl(wip_supply_type,0)
2530: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
2531: WHERE 1 = 1
2532: AND row_type = G_ROW_TP_ALL_TASK
2533: --AND crossdock_type > 1
2534: AND backorder_delivery_detail > 0;
2594: IF p_item_drop_flag <> 'Y' THEN
2595:
2596: l_progress := '45';
2597: -- LPN don't have contents, so insert a dummy row
2598: INSERT INTO WMS_PUTAWAY_GROUP_TASKS_GTMP
2599: (
2600: ORGANIZATION_ID
2601: ,LPN_ID
2602: ,PARENT_LPN_ID
2630: -- LPN has contents so query from MTRL,WDT and insert into temp table
2631:
2632: l_progress := '50';
2633: --Data has to be ordered in the temp table later before processing, because ORDER BY during insert is not supported
2634: INSERT INTO WMS_PUTAWAY_GROUP_TASKS_GTMP
2635: (
2636: ORGANIZATION_ID
2637: ,TRANSACTION_TEMP_ID
2638: ,TRANSACTION_HEADER_ID
2955: IF (l_debug = 1) THEN
2956: DEBUG('Resetting the xdock related cols for temp_id ' || l_tempid_tab(i) ,l_proc_name,9);
2957: END IF;
2958:
2959: UPDATE WMS_PUTAWAY_GROUP_TASKS_GTMP
2960: SET wip_supply_type = 0
2961: ,backorder_delivery_detail = 0
2962: ,crossdock_type = 0
2963: WHERE transaction_temp_id = l_tempid_tab(i);
2985: l_progress := '370';
2986:
2987: -- Update back these details into the temp table
2988: FORALL i IN 1 .. l_rowid_tab.COUNT
2989: UPDATE WMS_PUTAWAY_GROUP_TASKS_GTMP
2990: SET WIP_JOB = l_job_tab(i)
2991: ,WIP_LINE = l_line_tab(i)
2992: ,WIP_DEPT = l_dept_tab(i)
2993: ,WIP_OP_SEQ = l_operation_seq_num_tab(i)
3647: SELECT ROWID
3648: ,transaction_temp_id
3649: ,show_message
3650: ,error_code
3651: FROM wms_putaway_group_tasks_gtmp
3652: WHERE row_type = G_ROW_TP_ALL_TASK;
3653:
3654: -- This cursor will get the MMTT details for the temp id passed
3655: CURSOR c_mmtt_cursor(v_transaction_temp_id NUMBER) IS
3807: END IF;
3808:
3809: -- Do the bulk update on the temp table with the ATF suggested dest sub/loc/lpn
3810: FORALL i IN 1 .. l_tempid_tab.COUNT
3811: UPDATE wms_putaway_group_tasks_gtmp
3812: SET dest_subinventory = l_dest_sub_tab(i)
3813: ,dest_locator = l_dest_loc_tab(i)
3814: ,into_lpn_id = l_into_lpn_id_tab(i)
3815: ,into_lpn_name = l_into_lpn_name_tab(i)
3948: BULK COLLECT
3949: INTO l_lpn_id_tab
3950: FROM WMS_LICENSE_PLATE_NUMBERS
3951: WHERE lpn_id IN ( SELECT DISTINCT lpn_id
3952: FROM wms_putaway_group_tasks_gtmp
3953: WHERE row_type = G_ROW_TP_ALL_TASK
3954: AND lpn_context <> 3
3955: )
3956: FOR UPDATE NOWAIT;
4040: SELECT DISTINCT
4041: lpn_id
4042: ,lpn_name
4043: ,lpn_level
4044: FROM WMS_PUTAWAY_GROUP_TASKS_GTMP
4045: WHERE consolidated_lpn_id IS NULL
4046: AND drop_type = G_DT_CONSOLIDATED_DROP
4047: ORDER BY lpn_level ASC;
4048:
5099:
5100: -- This cursor will get the MMTTs assoicated with the group_id passed from the temp table
5101: CURSOR c_tmp_mmtt_cursor IS
5102: SELECT transaction_temp_id
5103: FROM wms_putaway_group_tasks_gtmp
5104: WHERE group_id = p_group_id
5105: AND row_type = G_ROW_TP_ALL_TASK;
5106:
5107: --BUG 5075410: The c_all_mmtt_cursor is used in the following scenarios:
9322: , NVL(mtrl.secondary_quantity_delivered, 0) --OPM Convergence
9323: , mtrl.secondary_uom_code --OPM Convergence
9324: FROM mtl_txn_request_lines mtrl
9325: WHERE mtrl.line_id IN (SELECT DISTINCT gtmp.move_order_line_id
9326: FROM wms_putaway_group_tasks_gtmp gtmp
9327: WHERE gtmp.group_id = p_group_id
9328: AND gtmp.transaction_header_id = p_txn_header_id
9329: AND gtmp.row_type = g_row_tp_all_task);
9330:
9342: , NVL(mtrl.secondary_quantity_delivered, 0) --OPM Convergence
9343: , mtrl.secondary_uom_code --OPM Convergence
9344: FROM mtl_txn_request_lines mtrl
9345: WHERE mtrl.line_id IN (SELECT DISTINCT gtmp.move_order_line_id
9346: FROM wms_putaway_group_tasks_gtmp gtmp
9347: WHERE gtmp.group_id = p_group_id
9348: AND gtmp.transaction_header_id = p_txn_header_id
9349: AND gtmp.row_type = g_row_tp_all_task)
9350: AND Nvl(mtrl.lot_number,'&*_') = Nvl(v_lot_number,'&*_')
9367: , wip_supply_type
9368: , secondary_quantity -- OPM Convergence
9369: , inspection_status
9370: , primary_uom_code
9371: FROM wms_putaway_group_tasks_gtmp
9372: WHERE group_id = p_group_id
9373: AND transaction_header_id = p_txn_header_id
9374: AND row_type = G_ROW_TP_ALL_TASK
9375: AND ( (v_disc = 'N') --no qty idsc
9755: , l_lot_control_code
9756: , l_serial_control_code
9757: , l_grp_sec_quantity
9758: , l_grp_sec_uom
9759: FROM wms_putaway_group_tasks_gtmp
9760: WHERE group_id = p_group_id
9761: AND transaction_header_id = p_txn_header_id
9762: AND row_type = G_ROW_TP_GROUP_TASK;
9763:
9978: l_progress := '80';
9979:
9980: --Now that we are ready with quantity calculations, mark the all tasks
9981: --in the current group for this move order line
9982: UPDATE wms_putaway_group_tasks_gtmp
9983: SET process_flag = 'Y'
9984: WHERE group_id = p_group_id
9985: AND transaction_header_id = p_txn_header_id
9986: AND move_order_line_id = l_mol_line_id;
10107: END IF;
10108:
10109: --Now that we are ready with quantity calculations, mark the all tasks
10110: --in the current group for this move order line
10111: UPDATE wms_putaway_group_tasks_gtmp
10112: SET process_flag = 'Y'
10113: WHERE group_id = p_group_id
10114: AND transaction_header_id = p_txn_header_id
10115: AND move_order_line_id = l_mol_line_id;
11708: -- Check there are no child LPNs and there is only one item left for Item drop
11709: BEGIN
11710: select count(DISTINCT inventory_item_id),count(DISTINCT lot_number),count(DISTINCT revision)
11711: into l_item_count,l_lot_count,l_rev_count
11712: from WMS_PUTAWAY_GROUP_TASKS_GTMP wpgtg
11713: where lpn_id = p_lpn_id
11714: and drop_type='ID'
11715: and row_type = 'Group Task'
11716: and not exists
11732: END IF;
11733:
11734: -- check LPN is fully allocated.
11735: select sum(primary_quantity) INTO l_qty_gtmp
11736: from WMS_PUTAWAY_GROUP_TASKS_GTMP
11737: where lpn_id = p_lpn_id
11738: and row_type = 'Group Task'
11739: and drop_type = 'ID';
11740: