55: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
56: ,base.LOCATOR_ID
57: ,base.PROJECT_ID
58: ,base.TASK_ID
59: from MTL_UNITS_OF_MEASURE bmuom
60: ,MTL_UNITS_OF_MEASURE muom
61: ,MTL_SYSTEM_ITEMS msi
62: ,WMS_TRX_DETAILS_TMP_V mptdtv
63: ,(
56: ,base.LOCATOR_ID
57: ,base.PROJECT_ID
58: ,base.TASK_ID
59: from MTL_UNITS_OF_MEASURE bmuom
60: ,MTL_UNITS_OF_MEASURE muom
61: ,MTL_SYSTEM_ITEMS msi
62: ,WMS_TRX_DETAILS_TMP_V mptdtv
63: ,(
64: select msei.secondary_inventory_name subinventory_code --changed
217: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
218: ,base.LOCATOR_ID
219: ,base.PROJECT_ID
220: ,base.TASK_ID
221: from MTL_UNITS_OF_MEASURE bmuom
222: ,MTL_UNITS_OF_MEASURE muom
223: ,MTL_SYSTEM_ITEMS msi
224: ,WMS_TRX_DETAILS_TMP_V mptdtv
225: ,(
218: ,base.LOCATOR_ID
219: ,base.PROJECT_ID
220: ,base.TASK_ID
221: from MTL_UNITS_OF_MEASURE bmuom
222: ,MTL_UNITS_OF_MEASURE muom
223: ,MTL_SYSTEM_ITEMS msi
224: ,WMS_TRX_DETAILS_TMP_V mptdtv
225: ,(
226: select msei.secondary_inventory_name subinventory_code --changed
378: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
379: ,base.LOCATOR_ID
380: ,base.PROJECT_ID
381: ,base.TASK_ID
382: from MTL_UNITS_OF_MEASURE bmuom
383: ,MTL_UNITS_OF_MEASURE muom
384: ,MTL_SYSTEM_ITEMS msi
385: ,WMS_TRX_DETAILS_TMP_V mptdtv
386: ,(
379: ,base.LOCATOR_ID
380: ,base.PROJECT_ID
381: ,base.TASK_ID
382: from MTL_UNITS_OF_MEASURE bmuom
383: ,MTL_UNITS_OF_MEASURE muom
384: ,MTL_SYSTEM_ITEMS msi
385: ,WMS_TRX_DETAILS_TMP_V mptdtv
386: ,(
387: select msei.secondary_inventory_name subinventory_code --changed
541: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
542: ,base.LOCATOR_ID
543: ,base.PROJECT_ID
544: ,base.TASK_ID
545: from MTL_UNITS_OF_MEASURE bmuom
546: ,MTL_UNITS_OF_MEASURE muom
547: ,MTL_SYSTEM_ITEMS msi
548: ,WMS_TRX_DETAILS_TMP_V mptdtv
549: ,(
542: ,base.LOCATOR_ID
543: ,base.PROJECT_ID
544: ,base.TASK_ID
545: from MTL_UNITS_OF_MEASURE bmuom
546: ,MTL_UNITS_OF_MEASURE muom
547: ,MTL_SYSTEM_ITEMS msi
548: ,WMS_TRX_DETAILS_TMP_V mptdtv
549: ,(
550: select msei.secondary_inventory_name subinventory_code -- changed
704: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
705: ,base.LOCATOR_ID
706: ,base.PROJECT_ID
707: ,base.TASK_ID
708: from MTL_UNITS_OF_MEASURE bmuom
709: ,MTL_UNITS_OF_MEASURE muom
710: ,MTL_SYSTEM_ITEMS msi
711: ,WMS_TRX_DETAILS_TMP_V mptdtv
712: ,(
705: ,base.LOCATOR_ID
706: ,base.PROJECT_ID
707: ,base.TASK_ID
708: from MTL_UNITS_OF_MEASURE bmuom
709: ,MTL_UNITS_OF_MEASURE muom
710: ,MTL_SYSTEM_ITEMS msi
711: ,WMS_TRX_DETAILS_TMP_V mptdtv
712: ,(
713: select msei.secondary_inventory_name subinventory_code -- changed
869: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
870: ,base.LOCATOR_ID
871: ,base.PROJECT_ID
872: ,base.TASK_ID
873: from MTL_UNITS_OF_MEASURE bmuom
874: ,MTL_UNITS_OF_MEASURE muom
875: ,MTL_SYSTEM_ITEMS msi
876: ,WMS_TRX_DETAILS_TMP_V mptdtv
877: ,(
870: ,base.LOCATOR_ID
871: ,base.PROJECT_ID
872: ,base.TASK_ID
873: from MTL_UNITS_OF_MEASURE bmuom
874: ,MTL_UNITS_OF_MEASURE muom
875: ,MTL_SYSTEM_ITEMS msi
876: ,WMS_TRX_DETAILS_TMP_V mptdtv
877: ,(
878: select msei.secondary_inventory_name subinventory_code -- changed
1036: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
1037: ,base.LOCATOR_ID
1038: ,base.PROJECT_ID
1039: ,base.TASK_ID
1040: from MTL_UNITS_OF_MEASURE bmuom
1041: ,MTL_UNITS_OF_MEASURE muom
1042: ,MTL_SYSTEM_ITEMS msi
1043: ,WMS_TRX_DETAILS_TMP_V mptdtv
1044: ,(
1037: ,base.LOCATOR_ID
1038: ,base.PROJECT_ID
1039: ,base.TASK_ID
1040: from MTL_UNITS_OF_MEASURE bmuom
1041: ,MTL_UNITS_OF_MEASURE muom
1042: ,MTL_SYSTEM_ITEMS msi
1043: ,WMS_TRX_DETAILS_TMP_V mptdtv
1044: ,(
1045: select mil.subinventory_code subinventory_code
1204: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
1205: ,base.LOCATOR_ID
1206: ,base.PROJECT_ID
1207: ,base.TASK_ID
1208: from MTL_UNITS_OF_MEASURE bmuom
1209: ,MTL_UNITS_OF_MEASURE muom
1210: ,MTL_SYSTEM_ITEMS msi
1211: ,WMS_TRX_DETAILS_TMP_V mptdtv
1212: ,(
1205: ,base.LOCATOR_ID
1206: ,base.PROJECT_ID
1207: ,base.TASK_ID
1208: from MTL_UNITS_OF_MEASURE bmuom
1209: ,MTL_UNITS_OF_MEASURE muom
1210: ,MTL_SYSTEM_ITEMS msi
1211: ,WMS_TRX_DETAILS_TMP_V mptdtv
1212: ,(
1213: select mil.subinventory_code subinventory_code
1373: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
1374: ,base.LOCATOR_ID
1375: ,base.PROJECT_ID
1376: ,base.TASK_ID
1377: from MTL_UNITS_OF_MEASURE bmuom
1378: ,MTL_UNITS_OF_MEASURE muom
1379: ,MTL_SYSTEM_ITEMS msi
1380: ,WMS_TRX_DETAILS_TMP_V mptdtv
1381: ,(
1374: ,base.LOCATOR_ID
1375: ,base.PROJECT_ID
1376: ,base.TASK_ID
1377: from MTL_UNITS_OF_MEASURE bmuom
1378: ,MTL_UNITS_OF_MEASURE muom
1379: ,MTL_SYSTEM_ITEMS msi
1380: ,WMS_TRX_DETAILS_TMP_V mptdtv
1381: ,(
1382: select mil.subinventory_code subinventory_code