DBA Data[Home] [Help]

APPS.WMS_RULE_8 dependencies on MTL_SECONDARY_LOCATORS

Line 1024: ,MTL_SECONDARY_LOCATORS msl

1020: ,mil.rowid
1021: from MTL_ITEM_LOCATIONS mil
1022: ,MTL_SECONDARY_INVENTORIES msei
1023: ,MTL_ITEM_SUB_INVENTORIES misi
1024: ,MTL_SECONDARY_LOCATORS msl
1025: where mil.organization_id = msei.organization_id
1026: and mil.subinventory_code = msei.secondary_inventory_name
1027: and NVL(msei.disable_date, sysdate+1) > sysdate
1028: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1173: ,MTL_SECONDARY_LOCATORS msl

1169: ,mil.rowid
1170: from MTL_ITEM_LOCATIONS mil
1171: ,MTL_SECONDARY_INVENTORIES msei
1172: ,MTL_ITEM_SUB_INVENTORIES misi
1173: ,MTL_SECONDARY_LOCATORS msl
1174: where mil.organization_id = msei.organization_id
1175: and mil.subinventory_code = msei.secondary_inventory_name
1176: and NVL(msei.disable_date, sysdate+1) > sysdate
1177: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1323: ,MTL_SECONDARY_LOCATORS msl

1319: ,mil.rowid
1320: from MTL_ITEM_LOCATIONS mil
1321: ,MTL_SECONDARY_INVENTORIES msei
1322: ,MTL_ITEM_SUB_INVENTORIES misi
1323: ,MTL_SECONDARY_LOCATORS msl
1324: where mil.organization_id = msei.organization_id
1325: and mil.subinventory_code = msei.secondary_inventory_name
1326: and NVL(msei.disable_date, sysdate+1) > sysdate
1327: and NVL(mil.disable_date, sysdate+1) > sysdate