DBA Data[Home] [Help]

APPS.WMS_RULE_9 dependencies on MTL_SECONDARY_LOCATORS

Line 1127: ,MTL_SECONDARY_LOCATORS msl

1123: ,mil.rowid
1124: from MTL_ITEM_LOCATIONS mil
1125: ,MTL_SECONDARY_INVENTORIES msei
1126: ,MTL_ITEM_SUB_INVENTORIES misi
1127: ,MTL_SECONDARY_LOCATORS msl
1128: where mil.organization_id = msei.organization_id
1129: and mil.subinventory_code = msei.secondary_inventory_name
1130: and NVL(msei.disable_date, sysdate+1) > sysdate
1131: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1293: ,MTL_SECONDARY_LOCATORS msl

1289: ,mil.rowid
1290: from MTL_ITEM_LOCATIONS mil
1291: ,MTL_SECONDARY_INVENTORIES msei
1292: ,MTL_ITEM_SUB_INVENTORIES misi
1293: ,MTL_SECONDARY_LOCATORS msl
1294: where mil.organization_id = msei.organization_id
1295: and mil.subinventory_code = msei.secondary_inventory_name
1296: and NVL(msei.disable_date, sysdate+1) > sysdate
1297: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1460: ,MTL_SECONDARY_LOCATORS msl

1456: ,mil.rowid
1457: from MTL_ITEM_LOCATIONS mil
1458: ,MTL_SECONDARY_INVENTORIES msei
1459: ,MTL_ITEM_SUB_INVENTORIES misi
1460: ,MTL_SECONDARY_LOCATORS msl
1461: where mil.organization_id = msei.organization_id
1462: and mil.subinventory_code = msei.secondary_inventory_name
1463: and NVL(msei.disable_date, sysdate+1) > sysdate
1464: and NVL(mil.disable_date, sysdate+1) > sysdate