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 188: from MTL_SYSTEM_ITEMS msi

184: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
185: ,base.LOCATOR_ID
186: ,base.PROJECT_ID
187: ,base.TASK_ID
188: from MTL_SYSTEM_ITEMS msi
189: ,WMS_TRX_DETAILS_TMP_V mptdtv
190: ,(
191: select msei.secondary_inventory_name subinventory_code --changed
192: ,mil.inventory_location_id locator_id

Line 316: from MTL_SYSTEM_ITEMS msi

312: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
313: ,base.LOCATOR_ID
314: ,base.PROJECT_ID
315: ,base.TASK_ID
316: from MTL_SYSTEM_ITEMS msi
317: ,WMS_TRX_DETAILS_TMP_V mptdtv
318: ,(
319: select msei.secondary_inventory_name subinventory_code --changed
320: ,mil.inventory_location_id locator_id

Line 446: from MTL_SYSTEM_ITEMS msi

442: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
443: ,base.LOCATOR_ID
444: ,base.PROJECT_ID
445: ,base.TASK_ID
446: from MTL_SYSTEM_ITEMS msi
447: ,WMS_TRX_DETAILS_TMP_V mptdtv
448: ,(
449: select msei.secondary_inventory_name subinventory_code -- changed
450: ,mil.inventory_location_id locator_id

Line 576: from MTL_SYSTEM_ITEMS msi

572: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
573: ,base.LOCATOR_ID
574: ,base.PROJECT_ID
575: ,base.TASK_ID
576: from MTL_SYSTEM_ITEMS msi
577: ,WMS_TRX_DETAILS_TMP_V mptdtv
578: ,(
579: select msei.secondary_inventory_name subinventory_code -- changed
580: ,mil.inventory_location_id locator_id

Line 708: from MTL_SYSTEM_ITEMS msi

704: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
705: ,base.LOCATOR_ID
706: ,base.PROJECT_ID
707: ,base.TASK_ID
708: from MTL_SYSTEM_ITEMS msi
709: ,WMS_TRX_DETAILS_TMP_V mptdtv
710: ,(
711: select msei.secondary_inventory_name subinventory_code -- changed
712: ,mil.inventory_location_id locator_id

Line 842: from MTL_SYSTEM_ITEMS msi

838: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
839: ,base.LOCATOR_ID
840: ,base.PROJECT_ID
841: ,base.TASK_ID
842: from MTL_SYSTEM_ITEMS msi
843: ,WMS_TRX_DETAILS_TMP_V mptdtv
844: ,(
845: select mil.subinventory_code subinventory_code
846: ,mil.inventory_location_id locator_id

Line 977: from MTL_SYSTEM_ITEMS msi

973: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
974: ,base.LOCATOR_ID
975: ,base.PROJECT_ID
976: ,base.TASK_ID
977: from MTL_SYSTEM_ITEMS msi
978: ,WMS_TRX_DETAILS_TMP_V mptdtv
979: ,(
980: select mil.subinventory_code subinventory_code
981: ,mil.inventory_location_id locator_id

Line 1113: from MTL_SYSTEM_ITEMS msi

1109: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
1110: ,base.LOCATOR_ID
1111: ,base.PROJECT_ID
1112: ,base.TASK_ID
1113: from MTL_SYSTEM_ITEMS msi
1114: ,WMS_TRX_DETAILS_TMP_V mptdtv
1115: ,(
1116: select mil.subinventory_code subinventory_code
1117: ,mil.inventory_location_id locator_id