DBA Data[Home] [Help]

APPS.WMS_RULE_8 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 591: ,MTL_ITEM_SUB_INVENTORIES misi

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
595: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 737: ,MTL_ITEM_SUB_INVENTORIES misi

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
741: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 885: ,MTL_ITEM_SUB_INVENTORIES misi

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
889: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1035: ,MTL_ITEM_SUB_INVENTORIES misi

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
1039: and mil.subinventory_code = msei.secondary_inventory_name

Line 1186: ,MTL_ITEM_SUB_INVENTORIES misi

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
1190: and mil.subinventory_code = msei.secondary_inventory_name

Line 1338: ,MTL_ITEM_SUB_INVENTORIES misi

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
1342: and mil.subinventory_code = msei.secondary_inventory_name