DBA Data[Home] [Help]

APPS.WMS_RULE_7 dependencies on MTL_SECONDARY_LOCATORS

Line 908: ,MTL_SECONDARY_LOCATORS msl

904: ,mil.rowid
905: from MTL_ITEM_LOCATIONS mil
906: ,MTL_SECONDARY_INVENTORIES msei
907: ,MTL_ITEM_SUB_INVENTORIES misi
908: ,MTL_SECONDARY_LOCATORS msl
909: where mil.organization_id = msei.organization_id
910: and mil.subinventory_code = msei.secondary_inventory_name
911: and NVL(msei.disable_date, sysdate+1) > sysdate
912: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1038: ,MTL_SECONDARY_LOCATORS msl

1034: ,mil.rowid
1035: from MTL_ITEM_LOCATIONS mil
1036: ,MTL_SECONDARY_INVENTORIES msei
1037: ,MTL_ITEM_SUB_INVENTORIES misi
1038: ,MTL_SECONDARY_LOCATORS msl
1039: where mil.organization_id = msei.organization_id
1040: and mil.subinventory_code = msei.secondary_inventory_name
1041: and NVL(msei.disable_date, sysdate+1) > sysdate
1042: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1169: ,MTL_SECONDARY_LOCATORS msl

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