DBA Data[Home] [Help]

APPS.WMS_RULE_9 dependencies on MTL_SECONDARY_LOCATORS

Line 1139: ,MTL_SECONDARY_LOCATORS msl

1135: ,mil.rowid
1136: from MTL_ITEM_LOCATIONS mil
1137: ,MTL_SECONDARY_INVENTORIES msei
1138: ,MTL_ITEM_SUB_INVENTORIES misi
1139: ,MTL_SECONDARY_LOCATORS msl
1140: where mil.organization_id = msei.organization_id
1141: and mil.organization_id=g_organization_id ---bug8425620 8665549
1142: and mil.subinventory_code = msei.secondary_inventory_name
1143: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1307: ,MTL_SECONDARY_LOCATORS msl

1303: ,mil.rowid
1304: from MTL_ITEM_LOCATIONS mil
1305: ,MTL_SECONDARY_INVENTORIES msei
1306: ,MTL_ITEM_SUB_INVENTORIES misi
1307: ,MTL_SECONDARY_LOCATORS msl
1308: where mil.organization_id = msei.organization_id
1309: and mil.organization_id=g_organization_id ---bug8425620 8665549
1310: and mil.subinventory_code = msei.secondary_inventory_name
1311: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1476: ,MTL_SECONDARY_LOCATORS msl

1472: ,mil.rowid
1473: from MTL_ITEM_LOCATIONS mil
1474: ,MTL_SECONDARY_INVENTORIES msei
1475: ,MTL_ITEM_SUB_INVENTORIES misi
1476: ,MTL_SECONDARY_LOCATORS msl
1477: where mil.organization_id = msei.organization_id
1478: and mil.organization_id=g_organization_id ---bug8425620 8665549
1479: and mil.subinventory_code = msei.secondary_inventory_name
1480: and NVL(msei.disable_date, sysdate+1) > sysdate