APPS.WMS_RULE_8 dependencies on MTL_SECONDARY_INVENTORIES

Line 155: ,MTL_SECONDARY_INVENTORIES msei

151: ,mil.SUGGESTED_WEIGHT
152: ,mil.LOCATION_SUGGESTED_UNITS
153: ,mil.rowid
154: from MTL_ITEM_LOCATIONS mil
155: ,MTL_SECONDARY_INVENTORIES msei
156: where mil.organization_id(+) = msei.organization_id
157: and mil.subinventory_code(+) = msei.secondary_inventory_name
158: and NVL(msei.disable_date, sysdate+1) > sysdate
159: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 300: ,MTL_SECONDARY_INVENTORIES msei

296: ,mil.SUGGESTED_WEIGHT
297: ,mil.LOCATION_SUGGESTED_UNITS
298: ,mil.rowid
299: from MTL_ITEM_LOCATIONS mil
300: ,MTL_SECONDARY_INVENTORIES msei
301: where mil.organization_id(+) = msei.organization_id
302: and mil.subinventory_code(+) = msei.secondary_inventory_name
303: and NVL(msei.disable_date, sysdate+1) > sysdate
304: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 444: ,MTL_SECONDARY_INVENTORIES msei

440: ,mil.SUGGESTED_WEIGHT
441: ,mil.LOCATION_SUGGESTED_UNITS
442: ,mil.rowid
443: from MTL_ITEM_LOCATIONS mil
444: ,MTL_SECONDARY_INVENTORIES msei
445: where mil.organization_id(+) = msei.organization_id
446: and mil.subinventory_code(+) = msei.secondary_inventory_name
447: and NVL(msei.disable_date, sysdate+1) > sysdate
448: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 590: ,MTL_SECONDARY_INVENTORIES msei

586: ,mil.SUGGESTED_WEIGHT
587: ,mil.LOCATION_SUGGESTED_UNITS
588: ,mil.rowid
589: from MTL_ITEM_LOCATIONS mil
590: ,MTL_SECONDARY_INVENTORIES msei
591: ,MTL_ITEM_SUB_INVENTORIES misi
592: where mil.organization_id(+) = msei.organization_id
593: and mil.organization_id=g_organization_id ---bug8425620 8665549
594: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 736: ,MTL_SECONDARY_INVENTORIES msei

732: ,mil.SUGGESTED_WEIGHT
733: ,mil.LOCATION_SUGGESTED_UNITS
734: ,mil.rowid
735: from MTL_ITEM_LOCATIONS mil
736: ,MTL_SECONDARY_INVENTORIES msei
737: ,MTL_ITEM_SUB_INVENTORIES misi
738: where mil.organization_id(+) = msei.organization_id
739: and mil.organization_id=g_organization_id ---bug8425620 8665549
740: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 884: ,MTL_SECONDARY_INVENTORIES msei

880: ,mil.SUGGESTED_WEIGHT
881: ,mil.LOCATION_SUGGESTED_UNITS
882: ,mil.rowid
883: from MTL_ITEM_LOCATIONS mil
884: ,MTL_SECONDARY_INVENTORIES msei
885: ,MTL_ITEM_SUB_INVENTORIES misi
886: where mil.organization_id(+) = msei.organization_id
887: and mil.organization_id=g_organization_id ---bug8425620 8665549
888: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 1034: ,MTL_SECONDARY_INVENTORIES msei

1030: ,mil.SUGGESTED_WEIGHT
1031: ,mil.LOCATION_SUGGESTED_UNITS
1032: ,mil.rowid
1033: from MTL_ITEM_LOCATIONS mil
1034: ,MTL_SECONDARY_INVENTORIES msei
1035: ,MTL_ITEM_SUB_INVENTORIES misi
1036: ,MTL_SECONDARY_LOCATORS msl
1037: where mil.organization_id = msei.organization_id
1038: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 1185: ,MTL_SECONDARY_INVENTORIES msei

1181: ,mil.SUGGESTED_WEIGHT
1182: ,mil.LOCATION_SUGGESTED_UNITS
1183: ,mil.rowid
1184: from MTL_ITEM_LOCATIONS mil
1185: ,MTL_SECONDARY_INVENTORIES msei
1186: ,MTL_ITEM_SUB_INVENTORIES misi
1187: ,MTL_SECONDARY_LOCATORS msl
1188: where mil.organization_id = msei.organization_id
1189: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 1337: ,MTL_SECONDARY_INVENTORIES msei

1333: ,mil.SUGGESTED_WEIGHT
1334: ,mil.LOCATION_SUGGESTED_UNITS
1335: ,mil.rowid
1336: from MTL_ITEM_LOCATIONS mil
1337: ,MTL_SECONDARY_INVENTORIES msei
1338: ,MTL_ITEM_SUB_INVENTORIES misi
1339: ,MTL_SECONDARY_LOCATORS msl
1340: where mil.organization_id = msei.organization_id
1341: and mil.organization_id=g_organization_id ---bug8425620 8665549