56: ,base.LOCATOR_ID
57: ,base.PROJECT_ID
58: ,base.TASK_ID
59: from MTL_SYSTEM_ITEMS msi
60: ,WMS_TRX_DETAILS_TMP_V mptdtv
61: ,(
62: select msei.secondary_inventory_name subinventory_code --changed
63: ,mil.inventory_location_id locator_id
64: ,msei.organization_id organization_id --changed
183: ,base.LOCATOR_ID
184: ,base.PROJECT_ID
185: ,base.TASK_ID
186: from MTL_SYSTEM_ITEMS msi
187: ,WMS_TRX_DETAILS_TMP_V mptdtv
188: ,(
189: select msei.secondary_inventory_name subinventory_code --changed
190: ,mil.inventory_location_id locator_id
191: ,msei.organization_id organization_id --changed
309: ,base.LOCATOR_ID
310: ,base.PROJECT_ID
311: ,base.TASK_ID
312: from MTL_SYSTEM_ITEMS msi
313: ,WMS_TRX_DETAILS_TMP_V mptdtv
314: ,(
315: select msei.secondary_inventory_name subinventory_code --changed
316: ,mil.inventory_location_id locator_id
317: ,msei.organization_id organization_id --changed
437: ,base.LOCATOR_ID
438: ,base.PROJECT_ID
439: ,base.TASK_ID
440: from MTL_SYSTEM_ITEMS msi
441: ,WMS_TRX_DETAILS_TMP_V mptdtv
442: ,(
443: select msei.secondary_inventory_name subinventory_code -- changed
444: ,mil.inventory_location_id locator_id
445: ,msei.organization_id organization_id -- changed
565: ,base.LOCATOR_ID
566: ,base.PROJECT_ID
567: ,base.TASK_ID
568: from MTL_SYSTEM_ITEMS msi
569: ,WMS_TRX_DETAILS_TMP_V mptdtv
570: ,(
571: select msei.secondary_inventory_name subinventory_code -- changed
572: ,mil.inventory_location_id locator_id
573: ,msei.organization_id organization_id -- changed
695: ,base.LOCATOR_ID
696: ,base.PROJECT_ID
697: ,base.TASK_ID
698: from MTL_SYSTEM_ITEMS msi
699: ,WMS_TRX_DETAILS_TMP_V mptdtv
700: ,(
701: select msei.secondary_inventory_name subinventory_code -- changed
702: ,mil.inventory_location_id locator_id
703: ,msei.organization_id organization_id -- changed
827: ,base.LOCATOR_ID
828: ,base.PROJECT_ID
829: ,base.TASK_ID
830: from MTL_SYSTEM_ITEMS msi
831: ,WMS_TRX_DETAILS_TMP_V mptdtv
832: ,(
833: select mil.subinventory_code subinventory_code
834: ,mil.inventory_location_id locator_id
835: ,mil.organization_id organization_id
960: ,base.LOCATOR_ID
961: ,base.PROJECT_ID
962: ,base.TASK_ID
963: from MTL_SYSTEM_ITEMS msi
964: ,WMS_TRX_DETAILS_TMP_V mptdtv
965: ,(
966: select mil.subinventory_code subinventory_code
967: ,mil.inventory_location_id locator_id
968: ,mil.organization_id organization_id
1094: ,base.LOCATOR_ID
1095: ,base.PROJECT_ID
1096: ,base.TASK_ID
1097: from MTL_SYSTEM_ITEMS msi
1098: ,WMS_TRX_DETAILS_TMP_V mptdtv
1099: ,(
1100: select mil.subinventory_code subinventory_code
1101: ,mil.inventory_location_id locator_id
1102: ,mil.organization_id organization_id