DBA Data[Home] [Help]

APPS.WMS_RULE_11 dependencies on MTL_SECONDARY_LOCATORS

Line 978: ,MTL_SECONDARY_LOCATORS msl

974: ,mil.rowid
975: from MTL_ITEM_LOCATIONS mil
976: ,MTL_SECONDARY_INVENTORIES msei
977: ,MTL_ITEM_SUB_INVENTORIES misi
978: ,MTL_SECONDARY_LOCATORS msl
979: where mil.organization_id = msei.organization_id
980: and mil.subinventory_code = msei.secondary_inventory_name
981: and NVL(msei.disable_date, sysdate+1) > sysdate
982: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1119: ,MTL_SECONDARY_LOCATORS msl

1115: ,mil.rowid
1116: from MTL_ITEM_LOCATIONS mil
1117: ,MTL_SECONDARY_INVENTORIES msei
1118: ,MTL_ITEM_SUB_INVENTORIES misi
1119: ,MTL_SECONDARY_LOCATORS msl
1120: where mil.organization_id = msei.organization_id
1121: and mil.subinventory_code = msei.secondary_inventory_name
1122: and NVL(msei.disable_date, sysdate+1) > sysdate
1123: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1261: ,MTL_SECONDARY_LOCATORS msl

1257: ,mil.rowid
1258: from MTL_ITEM_LOCATIONS mil
1259: ,MTL_SECONDARY_INVENTORIES msei
1260: ,MTL_ITEM_SUB_INVENTORIES misi
1261: ,MTL_SECONDARY_LOCATORS msl
1262: where mil.organization_id = msei.organization_id
1263: and mil.subinventory_code = msei.secondary_inventory_name
1264: and NVL(msei.disable_date, sysdate+1) > sysdate
1265: and NVL(mil.disable_date, sysdate+1) > sysdate