DBA Data[Home] [Help]

APPS.WMS_RULE_10 dependencies on MTL_SYSTEM_ITEMS

Line 59: from MTL_SYSTEM_ITEMS msi

55: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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

Line 186: from MTL_SYSTEM_ITEMS msi

182: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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

Line 312: from MTL_SYSTEM_ITEMS msi

308: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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

Line 440: from MTL_SYSTEM_ITEMS msi

436: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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

Line 568: from MTL_SYSTEM_ITEMS msi

564: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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

Line 698: from MTL_SYSTEM_ITEMS msi

694: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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

Line 830: from MTL_SYSTEM_ITEMS msi

826: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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

Line 963: from MTL_SYSTEM_ITEMS msi

959: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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

Line 1097: from MTL_SYSTEM_ITEMS msi

1093: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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