DBA Data[Home] [Help]

APPS.WMS_RULE_13 dependencies on MTL_SECONDARY_LOCATORS

Line 866: ,MTL_SECONDARY_LOCATORS msl

862: ,mil.rowid
863: from MTL_ITEM_LOCATIONS mil
864: ,MTL_SECONDARY_INVENTORIES msei
865: ,MTL_ITEM_SUB_INVENTORIES misi
866: ,MTL_SECONDARY_LOCATORS msl
867: where mil.organization_id = msei.organization_id
868: and mil.subinventory_code = msei.secondary_inventory_name
869: and NVL(msei.disable_date, sysdate+1) > sysdate
870: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 989: ,MTL_SECONDARY_LOCATORS msl

985: ,mil.rowid
986: from MTL_ITEM_LOCATIONS mil
987: ,MTL_SECONDARY_INVENTORIES msei
988: ,MTL_ITEM_SUB_INVENTORIES misi
989: ,MTL_SECONDARY_LOCATORS msl
990: where mil.organization_id = msei.organization_id
991: and mil.subinventory_code = msei.secondary_inventory_name
992: and NVL(msei.disable_date, sysdate+1) > sysdate
993: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1113: ,MTL_SECONDARY_LOCATORS msl

1109: ,mil.rowid
1110: from MTL_ITEM_LOCATIONS mil
1111: ,MTL_SECONDARY_INVENTORIES msei
1112: ,MTL_ITEM_SUB_INVENTORIES misi
1113: ,MTL_SECONDARY_LOCATORS msl
1114: where mil.organization_id = msei.organization_id
1115: and mil.subinventory_code = msei.secondary_inventory_name
1116: and NVL(msei.disable_date, sysdate+1) > sysdate
1117: and NVL(mil.disable_date, sysdate+1) > sysdate