DBA Data[Home] [Help]

APPS.WMS_RULE_8 dependencies on MTL_SECONDARY_LOCATORS

Line 1036: ,MTL_SECONDARY_LOCATORS msl

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

Line 1187: ,MTL_SECONDARY_LOCATORS msl

1183: ,mil.rowid
1184: from MTL_ITEM_LOCATIONS mil
1185: ,MTL_SECONDARY_INVENTORIES msei
1186: ,MTL_ITEM_SUB_INVENTORIES misi
1187: ,MTL_SECONDARY_LOCATORS msl
1188: where mil.organization_id = msei.organization_id
1189: and mil.organization_id=g_organization_id ---bug8425620 8665549
1190: and mil.subinventory_code = msei.secondary_inventory_name
1191: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1339: ,MTL_SECONDARY_LOCATORS msl

1335: ,mil.rowid
1336: from MTL_ITEM_LOCATIONS mil
1337: ,MTL_SECONDARY_INVENTORIES msei
1338: ,MTL_ITEM_SUB_INVENTORIES misi
1339: ,MTL_SECONDARY_LOCATORS msl
1340: where mil.organization_id = msei.organization_id
1341: and mil.organization_id=g_organization_id ---bug8425620 8665549
1342: and mil.subinventory_code = msei.secondary_inventory_name
1343: and NVL(msei.disable_date, sysdate+1) > sysdate