DBA Data[Home] [Help]

APPS.WMS_RULE_10 dependencies on MTL_SECONDARY_LOCATORS

Line 927: ,MTL_SECONDARY_LOCATORS msl

923: ,mil.rowid
924: from MTL_ITEM_LOCATIONS mil
925: ,MTL_SECONDARY_INVENTORIES msei
926: ,MTL_ITEM_SUB_INVENTORIES misi
927: ,MTL_SECONDARY_LOCATORS msl
928: where mil.organization_id = msei.organization_id
929: and mil.subinventory_code = msei.secondary_inventory_name
930: and NVL(msei.disable_date, sysdate+1) > sysdate
931: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1060: ,MTL_SECONDARY_LOCATORS msl

1056: ,mil.rowid
1057: from MTL_ITEM_LOCATIONS mil
1058: ,MTL_SECONDARY_INVENTORIES msei
1059: ,MTL_ITEM_SUB_INVENTORIES misi
1060: ,MTL_SECONDARY_LOCATORS msl
1061: where mil.organization_id = msei.organization_id
1062: and mil.subinventory_code = msei.secondary_inventory_name
1063: and NVL(msei.disable_date, sysdate+1) > sysdate
1064: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1194: ,MTL_SECONDARY_LOCATORS msl

1190: ,mil.rowid
1191: from MTL_ITEM_LOCATIONS mil
1192: ,MTL_SECONDARY_INVENTORIES msei
1193: ,MTL_ITEM_SUB_INVENTORIES misi
1194: ,MTL_SECONDARY_LOCATORS msl
1195: where mil.organization_id = msei.organization_id
1196: and mil.subinventory_code = msei.secondary_inventory_name
1197: and NVL(msei.disable_date, sysdate+1) > sysdate
1198: and NVL(mil.disable_date, sysdate+1) > sysdate