DBA Data[Home] [Help]

APPS.WMS_RULE_7 dependencies on MTL_SECONDARY_LOCATORS

Line 920: ,MTL_SECONDARY_LOCATORS msl

916: ,mil.rowid
917: from MTL_ITEM_LOCATIONS mil
918: ,MTL_SECONDARY_INVENTORIES msei
919: ,MTL_ITEM_SUB_INVENTORIES misi
920: ,MTL_SECONDARY_LOCATORS msl
921: where mil.organization_id = msei.organization_id
922: and mil.organization_id=g_organization_id ---bug8425620 8665549
923: and mil.subinventory_code = msei.secondary_inventory_name
924: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1052: ,MTL_SECONDARY_LOCATORS msl

1048: ,mil.rowid
1049: from MTL_ITEM_LOCATIONS mil
1050: ,MTL_SECONDARY_INVENTORIES msei
1051: ,MTL_ITEM_SUB_INVENTORIES misi
1052: ,MTL_SECONDARY_LOCATORS msl
1053: where mil.organization_id = msei.organization_id
1054: and mil.organization_id=g_organization_id ---bug8425620 8665549
1055: and mil.subinventory_code = msei.secondary_inventory_name
1056: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1185: ,MTL_SECONDARY_LOCATORS msl

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